10 Replies Latest reply: Aug 24, 2013 7:19 AM by botang(唐波) RSS

    SELECTing expdp dump files

    Prem Kumar

      Dear Experts,

       

      Can we read the export dumps created using expdp using ORACLE_DATAPUMP driver (11.2.0.3)?

       

      For example:

       

      1) Export a table using expdp

       

      expdp testuser/testuser DIRECTORY=TEST_DUR tables=TABLE_1 DUMPFILE=test.dmp  LOGFILE=test.log

       

      2) Read the dump file created in step-1

       

      CREATE TABLE my_test(

      id number)

        ORGANIZATION EXTERNAL (

           TYPE ORACLE_DATAPUMP

           DEFAULT DIRECTORY test_dir

           LOCATION ('test.dmp')

        )REJECT LIMIT UNLIMITED;

       

      select * from my_test;

       

      *

      ERROR at line 1:

      ORA-29913: error in executing ODCIEXTTABLEOPEN callout

      ORA-31619: invalid dump file "/u08/export/test.dmp"

       

       

       

      Here's the version info:

       

      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

      PL/SQL Release 11.2.0.3.0 - Production

      CORE 11.2.0.3.0 Production

      TNS for Linux: Version 11.2.0.3.0 - Production

      NLSRTL Version 11.2.0.3.0 - Production

       

      Is it possible to read the dumpfile like this????

       

       

      Appreciate your answer in this regard.

       

      Thanks

       

      P