DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SQL*LOADER Advise required...

  1. #1
    Join Date
    Jul 2000
    Location
    Pune, India
    Posts
    80
    Dear DBA's

    I require your advise regarding running SQL*LOADER continuecely for multiple Tables. I have have created seprate Control file, Datafile for each table. now this I want to insert into Oracle through SQL*LOADER for that I do

    SQLLDR userid=USERNAME/PASS@DB DIRECT=TRUE control=TABLENAME.CTL log=TABLENAME.LOG ERRORS=10000000

    this works properly. But every time I have to execute this command line by changing different TABLENAME control file and log file. So every time there will be login. Can I avoid this and execute SQLLDR only once for all controlfiles. Please Help.

    Thanks & Regards
    Shailesh

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    As far I know its not possible, but you can create different loader scripts and trigger them on specified time using cron (on Unix) or at (on NT).

  3. #3
    Join Date
    Dec 2000
    Posts
    126
    We use a script file contents the loader :

    /dw1/createdb/sql/loader/ldr/dwstt_store_type.ldr
    /dw1/createdb/sql/loader/ldr/dwbyg_buy_grp.ldr
    /dw1/createdb/sql/loader/ldr/dwbng_banner_grp.ldr
    /dw1/createdb/sql/loader/ldr/dwcus_cust_mst.ldr


    where /dw1/createdb/sql/loader/ldr/dwcus_cust_mst.ldr
    is:

    sqlldr dwdba/dwdba control=/dw1/createdb/sql/loader/ctl/dwcus_cust_mst.ctl error
    s=999999 direct=false log=/dw1/createdb/sql/loader/logs/dwcus_cust_mst.log disca
    rd=/dw1/createdb/sql/loader/logs/dwcus_cust_mst.log


    and /dw1/createdb/sql/loader/ldr/dwbng_banner_grp.ldr is:

    sqlldr dwdba/dwdba control=/dw1/createdb/sql/loader/ctl/dwbng_banner_grp.ctl dir
    ect=false errors=999999 log=/dw1/createdb/sql/loader/logs/dwbng_banner_grp.log
    discard=/dw1/createdb/sql/loader/logs/dwbng_banner_grp.discard


    hope this will help you.

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