Re: Why is this external table not working???
Date: Sat, 12 Jan 2008 07:11:02 -0800 (PST)
Message-ID: <ca617c6c-0089-41f5-b62c-12cb16782fc7@f47g2000hsd.googlegroups.com>
On Jan 11, 9:12 pm, DA Morgan <damor..._at_psoug.org> wrote:
> ame..._at_iwc.net wrote:
> > On Jan 11, 5:46 pm, DA Morgan <damor..._at_psoug.org> wrote:
> >> ame..._at_iwc.net wrote:
> >>> 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???
> >> You have a choice ... you can either be positional or delimited but you
> >> can't choose to be both.
>> >> damor..._at_x.washington.edu (replace x with u to respond)
> >> My recommendation would be tab delimited and then select what you want.
> >> --
> >> Daniel A. Morgan
> >> Oracle Ace Director & Instructor
> >> University of Washington
> >> Puget Sound Oracle Users Groupwww.psoug.org-Hide quoted text -
>
> >> - Show quoted text -
>
> > Can I forget about the whole delimiter thingy? Can I say that a tab
> > character is X amount of spaces, and then just use positions?
>
> No.
> --
> Daniel A. Morgan
> Oracle Ace Director & Instructor
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>
> - Show quoted text -
Amerar, why did you cross post this? Posting to one oracle newgroup at a time is usually sufficient.
HTH -- Mark D Powell -- Received on Sat Jan 12 2008 - 09:11:02 CST