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!

Using original Oracle export to transfer meta-data from PROD to QA

amitavachatterjee1975Feb 12 2013 — edited Feb 13 2013

Hi Gurus,

I have to use original export to transfer meta-data from PROD to QA since source Oracle version is 9i.

When I do this it returns no rows:
select * from dba_directories;

I need to know what are the exact steps to create an export file MI_PROD.DMP in a dir say /usr/oracle/export.
I have SYS access to PROD.

Thanks
Amitava.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 13 2013

Added on Feb 12 2013

#database-key-features, #export-import-sql-loader-external-tables

9 comments

392 views