-
control files in oracle 9i !!
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 ..
Last edited by vinodrn; 11-26-2002 at 07:49 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|