example of an external table which accepts all records from a file

Vote count:

0

please can one tell me how to accept all records from a file so that no record should go to discard or bad file using external table concept.

below is the code

create table ext_tab2 (

mprn char(10))

ORGANIZATION EXTERNAL (

TYPE ORACLE_LOADER

DEFAULT DIRECTORY IMPORT

ACCESS PARAMETERS (

RECORDS DELIMITED BY NEWLINE

BADFILE IMPORT:'test.bad'

LOGFILE IMPORT:'test.log'

FIELDS TERMINATED BY ','

(mprn char(10)))

LOCATION ('abc.txt')

)

PARALLEL 5

REJECT LIMIT UNLIMITED;

all the data from file('abc.txt') should get inserted into ext_tab2 table .

asked 1 min ago

y2j

57

example of an external table which accepts all records from a file