control files in oracle 9i !!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 1 of 1

Thread: control files in oracle 9i !!

  1. #1
    Join Date
    Nov 2002
    Location
    Bangalore
    Posts
    1

    Question 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 06: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
  •  



Click Here to Expand Forum to Full Width