| EXPORT/IMPORT [message #148364] |
Wed, 23 November 2005 16:16 |
ozzy80
Messages: 55
Registered: June 2005
|
Member |
|
|
Hello,
I am sure the experts might have done this before..
I have oracle 9.2.0.6, on SOlaris 8..
I was trying to create a test box and had the DBA install the DB... I wanted to try EXP/IMP myself...
so exported the dev DB with..
exp scott/tiger file=112305.dmp log=112305.log FULL=Y
exp user2/pass file=file2.dmp log=file2.log full=y
(2 diff schemas in same DB)
then tried importing this to the new DB with...
imp scott/tiger file=112305.dmp fromuser=scott log=112305_imp.log
imp user2/pass file=user2.dmp fromuser=user2 log=file2_imp.log
But the problem was, I needed another user 'User3' and the imp completed but with warnings... so I created the user3 and again ran the above imp command... I did that couple more times...
Obviously, I am pretty new to this DBA side of oracle... now I see data in some tables and few others are empty... I also read that if you run multiple IMP commands then you run into a problem of having to create duplicate constraints...
So, I was thining is there a way i can clean up this mess... or have I created a mess at all????
If yes, then plz let me know what I could do to start afresh...
Any help is greatly appreciated...
thanks,
Ozzy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
