6 Replies Latest reply: Sep 6, 2013 3:53 PM by 937454 RSS

    External table error while extracting data

    937454

      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.