hi
sorry to bother you guys
i have a text file as below
i am trying to store the same in external table
(last column of the record is truncated)
my sql for external table is
create table cts_clg2
(
col char(1),
col1 char( 9 ),
col2 char( 9 ),
col3 char( 9 ),
col4 char( 9 ),
col5 char( 13 ),
col6 char( 11 ),
col7 char( 10 ),
col8 char( 18 ),
col9 char( 18 ),
col10 char( 7 ),
col11 char( 26 ),
col12 char( 26 ),
col13 char( 45 )
)
ORGANIZATION EXTERNAL
( TYPE ORACLE\_LOADER
DEFAULT DIRECTORY HRK\_NEW
ACCESS PARAMETERS
(
records delimited by newline
FIELDS TERMINATED BY '|'
MISSING FIELD VALUES ARE NULL
col char(1),
col1 char( 9 ),
col2 char( 9 ),
col3 char( 9 ),
col4 char( 9 ),
col5 char( 13 ),
col6 char( 11 ),
col7 char( 10 ),
col8 char( 18 ),
col9 char( 18 ),
col10 char( 7 ),
col11 char( 26 ),
col12 char( 26 ),
col13 char( 45 )
)
location
('OW\_240516\_001\_KJSB\_CTS\_01 (1).TXT')
)
REJECT LIMIT UNLIMITED
table created
select * from cts_clg2
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 "identifier":
expecting one of: "column, (, reject"
KUP-01008: the bad identifier was: col
KUP-01007: at line 4 column 3
not able to solve the issue....
please help me