-
Problem in Export from 8i to 9i
Hello All,
I do have one user called 'GS20012002' In Oracle 8i. Now i want that user's all data into my Oracle 9i Database. I have created user 'gs20012002' in oracle 9i.
I want to perform Export/Import.
Can Any one tell me the perfect syntax for doing this???
-
exp
then imp
with the option help=y
-
Originally Posted by hirani_prashant
Can Any one tell me the perfect syntax for doing this???
Some authors argue there is not such a thing as the "perfect syntax", you may want to settle with one that works for you.
Let me add two hints to Dave's post...
1- Check exp/imp compatibility matrix -Metalink
2- When following Dave's directions direct your attention to fromuser/touser options
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|