CODEWITHSUNDEEP
oracle-databaseexternal-tables
siavash
siavash

Reputation: 11

How to use expdp dumpfile as external oracle_datapump

I couldn't use dump expdp output file in to external table with access driver. Is it possible to use expdp output file in to external table? Is there any special solution for this case or the structure is so different?

script :

CREATE TABLE item_import (
    item_id NUMBER
    , item_barcode VARCHAR2(20)
    , item_type NUMBER
    , item_title VARCHAR2(60)
    , item_subtitle VARCHAR2(60)
    , item_rating VARCHAR2(8)
    , item_rating_agency VARCHAR2(4)
    , item_release_date DATE
    , created_by NUMBER
    , creation_date DATE
    , last_updated_by NUMBER
    , last_update_date DATE)
    ORGANIZATION EXTERNAL
    ( TYPE oracle_datapump 
        DEFAULT DIRECTORY "download"  
        LOCATION ('item_export.dmp')
);

ERROR at line 1:

ORA-29913: error IN executing ODCIEXTTABLEOPEN callout

Upvotes: 1

Views: 887

Answers (1)

Giova
Giova

Reputation: 1127

seems that you wrong the table definition. Try the following:

 CREATE TABLE inventories_xt
  ORGANIZATION EXTERNAL
  (
    TYPE ORACLE_DATAPUMP
    DEFAULT DIRECTORY def_dir1
    LOCATION ('inv_xt.dmp')
  )
  AS SELECT * FROM inventories;

Pls. Review the following: The ORACLE_DATAPUMP Access Driver

Upvotes: 1

Related Questions