Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> exernal table syntax

exernal table syntax

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Wed, 01 Nov 2006 07:46:58 -0500
Message-Id: <s54850fd.065@groupwise.gcrta.org>


I am getting an error on the following:
CREATE TABLE rta.obd_po_data (po_number CHAR(8))   ORGANIZATION EXTERNAL
  (TYPE ORACLE_LOADER
   DEFAULT DIRECTORY f_temp_dir
   ACCESS PARAMETERS
 (FIELDS RTRIM
            (po_number (1:8) CHAR(8))
 NOLOGFILE
 )
   LOCATION ('obd_po_data.dat')
   )  

The table creates but fails when referenced.  

select * from rta.obd_po_data
*
ERROR at line 1:

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 "nologfile": expecting one of: "exit"
KUP-01007: at line 3 column 2
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 01 2006 - 06:46:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US