Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Location
    India
    Posts
    60

    Unanswered: Insert scripts in flat file to be executed

    Hi,
    I have .dat file having INSERT scripts to insert a data into a table.But the file is of 3.21GB.So how can i execute this file so that the data can be inserted into a table.
    Here i am not supposed to split and run the scripts page by page.
    I dont have stream data or any delimiter separated file for this table data.
    Please provide me the way to solve this problem?
    Thanks in Advance
    ~V~
    Thanks & Regards
    Manikandan

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    did you consider sqlldr to do the job. Modify the flat file with sed, write a sqlldr ctl file.

    for sqlldr you can find documentation here:
    http://download-east.oracle.com/docs...920/a96652.pdf

    sqlldr will the job do much faster than millions of single inserts

    instead of manipulation the flat file with sed you can use filler options for the ctl file

  3. #3
    Join Date
    Aug 2002
    Location
    India
    Posts
    60
    Hi,
    Thanks a lot...But My file has..

    INSERT INTO TABLE1(col1,col2..........)
    VALUES(..........)....

    Here it contains some millions of records...How can it be loaded using sqlloader??I know sqlloader can load flat file into table...I have used it also....
    BUt
    is it something called
    sta file.dat

    or
    sta file.sql

    where file.sql contains the insert scripts.
    Thanks & Regards
    Manikandan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •