Problem in Export from 8i to 9i
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???
with the option help=y
Some authors argue there is not such a thing as the "perfect syntax", you may want to settle with one that works for you.
Originally Posted by hirani_prashant
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.
Click Here to Expand Forum to Full Width