This discussion is archived
10 Replies Latest reply: Aug 24, 2013 5:19 AM by botang(唐波) RSS

SELECTing expdp dump files

Prem Kumar Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points