Funda 2 > Text To Tables 2 > Text _ Tables 2

sql> sql> --------- to use these steps before the user want the crate any directory privellage fo the user sql> sql> sql> sql> grant create any directory to scott; grant succeeded. sql> conn scott/tiger@iimdba connected. sql> sql> create directory dir as 'd:\' 2 ; create directory dir as 'd:\' * error at line 1: ora-00955: name is already used by an existing object sql>

create directory dir1 as 'd:\';

directory created. sql> create table xxxx(sno number,name varchar2(10)); table created. sql> drop table

xxxx;

table dropped. sql> create table xxxx(sno number,name varchar2(10)) 2 oraganization external 3 (type oracle_loader 4 default directory dir1 5 access parameters 6 (records delimited by newline 7 badfile 'xx_bad.bad' 8 logfile 'xx_log.log' 9 fields terminated by ',' 10 (sno number,name varchar)) 11 location('record.txt') 12 parallel 5 13 reject limit 200); oraganization external * error at line 2: ora-00922: missing or invalid option sql> ed wrote file afiedt.buf 1 2 3

create table xxxx(sno number,name varchar2(10)) organization external (type oracle_loader

4 default directory dir1 5 access parameters 6 (records delimited by newline 7 badfile 'xx_bad.bad' 8 logfile 'xx_log.log' 9 fields terminated by ',' 10 (sno number,name varchar)) 11 location('record.txt') 12 parallel 5 13* reject limit 200) sql> / parallel 5 * error at line 12: ora-00907: missing right parenthesis sql> ed wrote file afiedt.buf 1 create table xxxx(sno number,name varchar2(10)) 2 organization external 3 (type oracle_loader 4 default directory dir1 5 access parameters 6 (records delimited by newline 7 badfile 'xx_bad.bad' 8 logfile 'xx_log.log' 9 fields terminated by ',' 10 (sno number,name varchar)) 11 location('record.txt') 12 parallel 5 13* reject limit 200 sql> / parallel 5 * error at line 12: ora-00907: missing right parenthesis sql> ed wrote file afiedt.buf 1 2 3 4 5 6 7 8 9 10 11 12 13* sql>

create table xxxx(sno number,name varchar2(10)) organization external (type oracle_loader default directory dir1 access parameters (records delimited by newline badfile 'xx_bad.bad' logfile 'xx_log.log' fields terminated by ',' (sno number,name varchar)) location('record.txt')) parallel 5 reject limit 200 /

table created. sql> select * from xxxx; select * from xxxx * 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: "comma, char, date, defaultif, decimal, double, float, integer, (, nullif, oracle_date, oracle_number, position, raw, recnum, ), unsigned, varrawc, varchar, varraw, varcharc, zoned" kup-01008: the bad identifier was: number kup-01007: at line 5 column 6 ora-06512: at "sys.oracle_loader", line 14 ora-06512: at line 1 sql> drop table xxxx; table dropped. sql> 2 3 4 5 6 7 8 9 10 11 12 13 14

create table xxxx(sno number,name varchar2(10)) organization external (type oracle_loader default directory dir1 access parameters (records delimited by newline badfile 'xx_bad.bad' logfile 'xx_log.log' fields terminated by ',' (sno number,name char)) location('record.txt')) parallel 5 reject limit 200 /

table created. sql> select * from xxxx; select * from xxxx * 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: "comma, char, date, defaultif, decimal, double, float, integer, (, nullif, oracle_date, oracle_number, position, raw, recnum, ), unsigned, varrawc, varchar, varraw, varcharc, zoned" kup-01008: the bad identifier was: number kup-01007: at line 5 column 7 ora-06512: at "sys.oracle_loader", line 14 ora-06512: at line 1 sql> spool off