8 Replies Latest reply: Jun 14, 2013 9:44 AM by Dean Gagne-Oracle RSS

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

    RK334

      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.