recipients of list
ORACLE-L [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: Exp Imp Overwirte
posiible
truncate is not an option?
Joe
[EMAIL PROTECTED] wrote:
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
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
You can use truncate command to delete all data from that tables and then
IMP.Hope this will help u .
-Seema
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Exp Imp Overwirte posiible or not?
Date: Tue, 27 Mar 2001 10
-L
Subject: RE: Exp Imp Overwirte posiible or not?
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
