recipients of list
ORACLE-L [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: Exp Imp Overwirte
posiible
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
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
an 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
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