Home » RDBMS Server » Server Utilities » Import problem.
Import problem. [message #72452] Fri, 20 June 2003 01:33 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10707
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)
Previous Topic: Urgent! nt server to solaris server oracle import
Next Topic: I offer a nice and cheap program to backup/restore Oracle 8 databases
Goto Forum:
  


Current Time: Sat Jun 29 13:48:41 CDT 2024