Database Software

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!

Import from 11G db to 10G dab

878979Aug 2 2011 — edited Aug 3 2011

Hi David,

I would need to export 11G database tables and import them to 10G database. I have exported from 11G using exp command. The command I have used is:

exp scott/tiger file=emp.dmp tables=emp,dept;

Now I need to import emp.dmp in Oracle 10G. Would the imp command for Oracle 10G work in this case? Is the command I need to use as given below?

imp scott/tiger file=emp.dmp full=yes

Can you please help me in this regard.

Thanks as always,

ChD

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 31 2011

Added on Aug 2 2011

#data-warehousing, #olap

2 comments

187 views