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

Quote:

---

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