This discussion is archived
6 Replies Latest reply: Sep 6, 2013 1:53 PM by 937454 RSS

External table error while extracting data

937454 Newbie
Currently Being Moderated

Hi,

My db version is:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

 

I am getting an error while running this piece of code:

 

CREATE TABLE extract_testdata

     ORGANIZATION EXTERNAL

     (TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY FID ACCESS PARAMETERS

     (NOBADFILE NOLOGFILE)

     LOCATION ('testdata.exp'))

     REJECT LIMIT UNLIMITED AS

     SELECT *

     FROM xe_testdata;

 

ERROR:

Error at Command Line:11 Column:0

Error report:

SQL Error: ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-29400: data cartridge error

KUP-00554: error encountered while parsing access parameters

KUP-01005: syntax error: found "identifier": expecting one of: "logfile, nologfile, version" etc..

KUP-01008: the bad identifier was: NOBADFILE

KUP-01007: at line 1 column 1

ORA-06512: at "SYS.ORACLE_DATAPUMP", line 19

29913. 00000 -  "error in executing %s callout"

*Cause:    The execution of the specified callout caused an error.

*Action:   Examine the error messages take appropriate action.

 

Please advice what is wrong with the code.

Legend

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