Import problem. [message #72452] |
Fri, 20 June 2003 01:33 |
rajmukesh
Messages: 14 Registered: March 2003
|
Junior Member |
|
|
Hi
I am trying to import one of my users data at remote site. I have a export from that end. Now i am trying to import that data into the same user at my end.I already have that user and it has some old data also. Now i want to overwrite that data by this new exported data. If i simply import then the old data will get overwrite or not? or i have to drop that user and import from this new exported data? suggest me the best way to do this. What parameters do I have to give in import command?
pls help
|
|
|
Re: Import problem. [message #72453 is a reply to message #72452] |
Fri, 20 June 2003 05:57 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
you can drop all the all the objects owned by user
or
just truncate the tables ( then make sure u have ingore=y in import)
|
|
|