Re: Why is this external table not working???

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.
>
> My recommendation would be tab delimited and then select what you want.
> --
> 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 -

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? Received on Fri Jan 11 2008 - 17:55:01 CST