Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: importing new data + overwriting old ?
You can drop those tables that are going to be re-created via the
import, or truncate the tables and set the 'ignore=Y' so that the
create table statements wil fail but the data will be imported
regardless. The advantage of pre-creating the tables is you can
customize the storage parameters....
Cheers, Robert Prendin
"Steven Cools" <Steven_at_digimap.be> wrote:
>hi,
>
>I tried to import a .dmp file (with the Data Manager in Oracle 7.3.2 under
>WinNT) that has the same structure as the current database in Oracle but
>got following error message:
>
> ''....object already exists" (I got this error message for every table I
>tried to import. I checked the mark
>'overwrite existings objects' in the options screen but that didn't seem to
>work. Maybe I could delete
>the current database (all tables) and import the .dmp file? Does anyone
>know what's the best way to
>do this ?
>
>thankx,
>
>Steven
>
>BTW: please respond by e-mail if possible
Received on Tue May 05 1998 - 09:07:32 CDT