RE: Export/Import issue.

2003-12-24 Thread Mercadante, Thomas F
Avnish, Are you absolutely sure that the target table is either gone before the import, or empty? You should not be getting a unique constraint violation if the table does not exists before import. The step that Oracle import follows for importing is: Create the table import the data create

RE: Export/Import issue.

2003-12-24 Thread Avnish.Rastogi
I am 100% positive . I tried this process 2-3 times using different approach but same output. I tried to create objects first using no data. I also tried to create objects as part of loading data but no difference. I enabled 10046 trace for the import process but that also didnt help, it

RE: Export/Import issue.

2003-12-24 Thread anu
I think data will never change like that. Are the owners the same. Or are you doing fromuser touser. You can use the show option to see the contents of the export dumpfile. Then make sure all objects are dropped. [EMAIL PROTECTED] wrote: I am 100% positive . I tried this process 2-3 times using

RE: Export/Import issue.

2003-12-24 Thread Avnish.Rastogi
Owners are different. I am using fromuser touser. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of anuSent: Wednesday, December 24, 2003 12:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Export/Import issue. I think data