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!

Is it possible to view/get the table data from a dump file

RK334Jun 13 2013 — edited Jun 14 2013

I have dmp files generated using expdp on oracle 11g..

expdp_schemas_18MAY2013_1.dmp

expdp_schemas_18MAY2013_2.dmp

expdp_schemas_18MAY2013_3.dmp

Can I use a parameter file given below to get the table data in to the sql file or impdp the only option to load the table data in to database.

vi test1.par

USERID="/ as sysdba"

DIRECTORY=DATA

dumpfile=expdp_schemas_18MAY2013%S.dmp

SCHEMAS=USER1,USER2

LOGFILE=user_dump_data.log

SQLFILE=user_dump_data.sql

and impdp parfile=test1.par.

This post has been answered by Dean Gagne-Oracle on Jun 14 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 12 2013

Added on Jun 13 2013

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

8 comments

5,710 views