The DESTROY option on an import indicates whether the CREATE TABLESPACE commands only
found in a full export should be executed. Setting DESTROY=Y destroys the data files
of the database being imported into. This is only used when you want to rebuild an
entire database, not to overwrite data in tables. If you really need the empty all the
tables in a schema, disable the constraints on the tables, truncate them, and reenable
the constraints. This will only work if the schema is self contained, and it's tables
are not used as a foreign key for a table in a different schema.
>>> [EMAIL PROTECTED] 03/27/01 01:50PM >>>
IIRC, there is a flag for import "destroy=y" to do what you want. This is
very dangerous and you should research all the implications before trying
it. If you don't have the docs, try http://technet.oracle.com and read up
on the import options.
Scott Shafer
San Antonio, TX
210-581-6217
> -----Original Message-----
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 1:46 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Exp Imp Overwirte posiible or not?
>
> Hi All,
> I want to import data from a user dump file but when i import data, i
> want
> to overwrite the existing data . Normally imp utility append data to
> existing rows. Requirement of application is such that we need to
> overwrite existing data without dropping objects and its dependent
> objects. Is it possible with exp , imp utilities or i have to delete data
> first and then import using imp utility.
> Is there any other possibility...
> Environment Oracle8i, Windows NT4
> TIA
>
> Azhar Siddiq
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).