RE: Exp Imp Overwirte posiible or not?

2001-03-28 Thread azhar
recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Exp Imp Overwirte posiible

Exp Imp Overwirte posiible or not?

2001-03-27 Thread azhar
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

Re: Exp Imp Overwirte posiible or not?

2001-03-27 Thread Joseph S. Testa
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

RE: Exp Imp Overwirte posiible or not?

2001-03-27 Thread William Beilstein
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

RE: Exp Imp Overwirte posiible or not?

2001-03-27 Thread Seema Singh
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

RE: Exp Imp Overwirte posiible or not?

2001-03-27 Thread Scott . Shafer
-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