Hi all,
We are using control files of the structure[ given below ] for
oracle 8i. Will it get changed for 9i?
load data
infile 'd:\app\loaderfiles\flat_file_name.txt'
badfile 'd:\app\load_log\bad_file_name.bad'
truncate
into table
(
column_name_1 position(1:9) CHAR,
column_name_2 position(28:47) CHAR,
column_name_3 position(48:62) CHAR,
column_name_4 constant 'USD'
)
waiting for responses ..
