Re: import question with data in table already

Jay Collins <jcollin_at_exis.net> wrote in message news:<Pine.LNX.4.33.0204021040330.11185-100000_at_tarpon.exis.net>...
> I have a tablespace with users data already in it. (our test machine) and
> I have a dump I'd like to import into it. Do I need to clear it first? If
> so, what is the easiest way without screwing up the stuff already there.
> does the IMP ignore=y over-write dups of the table space already has data
> in it?
>
>
> Thanks

If you don't have Primary Keys on those tables you should clear them. If you have Primary Keys on those tables the insert will fail and will NOT overwrite/update existing data. So, if you want to update you should either clear the tables or set up a smarter mechanism (import to a different user and use sql*plus to insert/update your records)

Hth

Sybrand Bakker
Senior Oracle DBA Received on Tue Apr 02 2002 - 20:53:24 CEST