Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exp and Imp in different OS platform

411122Mar 15 2004 — edited Mar 16 2004

I was asked to do a full exp for a v815DB in NT platform, and full imp into a v920DB in Lunix. The purpose is to move ALL data to a new DB for test.
ie.
exp system/pass file=full.dmp full=y
imp system/pass file=full.dmp full=y
I am not sure if or not this could be done. First, SYSTEM,REDO and TEMP of v815 shouldn't be imported into db of v920,I think. Second, lots of DDL will not work because file system structure is different. I can use user-mode,one-by-one user imp to avoid 1st issue, but the 2nd issue is there.
ie.
imp system/pass file=full.dmp fromuser=user1 touser=user1
imp system/pass file=full.dmp fromuser=user2 touser=user2
......

In that case, what I should do to finish this task?
Thanks
Robin

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 13 2004

Added on Mar 15 2004

#general-database-discussions

4 comments

1,422 views