Why is this external table not working???
From: <amerar_at_iwc.net>
Date: Fri, 11 Jan 2008 15:24:07 -0800 (PST)
Message-ID: <fb00d24f-d3da-4c42-81a6-71e8e2219556@m77g2000hsc.googlegroups.com>
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
FIELDS TERMINATED BY '|'
MISSING FIELD VALUES ARE NULL (
"ID" POSITION(1:5) CHAR(5),
"REPORT_DATE" POSITION(49:8) CHAR(8),
"ESTIMATE" POSITION(65:8) CHAR(8))
REJECT LIMIT 50; ID REPORT_D ESTIMATE
----- -------- --------
Date: Fri, 11 Jan 2008 15:24:07 -0800 (PST)
Message-ID: <fb00d24f-d3da-4c42-81a6-71e8e2219556@m77g2000hsc.googlegroups.com>
This is driving me crazy!
Ok, I have an external table that is tab delimited. I am not interested in all of the fields, jsut a few of them. My table definition is below. But, it is not working! Here is my definition and what happends when I query the data:
CREATE TABLE TARGET_PRICE_EST_EXT
(
ID VARCHAR2(5), REPORT_DATE VARCHAR2(8), ESTIMATE VARCHAR2(8)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY INDATA_DIRECTORY
ACCESS PARAMETERS
( RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY '|'
MISSING FIELD VALUES ARE NULL (
"ID" POSITION(1:5) CHAR(5),
"REPORT_DATE" POSITION(49:8) CHAR(8),
"ESTIMATE" POSITION(65:8) CHAR(8))
)
LOCATION (INDATA_DIRECTORY:'SnDailyUpload.txt')
)
REJECT LIMIT 50; ID REPORT_D ESTIMATE
----- -------- --------
AAD A 7.20 11 5 00949 JON A 6.71 47. /2005 5 CCFG 0 8.20 0 7 5 0185 EERT 3.80 3.8 2007 -99 LLF A 82 10.00 007 3 03
Any thoughts??? Received on Fri Jan 11 2008 - 17:24:07 CST