automating & scheduling sqlloader process
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: automating & scheduling sqlloader process

Hybrid View

  1. #1
    Join Date
    Dec 2002
    Posts
    110

    automating & scheduling sqlloader process

    Hi guys


    I have a database (oracle8i 8.1.7) on winnt machine where a lot of data is loaded through sqlldr every fortnight.This data is used for generating specific reports required to be submitted every fortnight.
    The data which we load into this databse comes from diverse systems which we keep in a central folder from where its uploaded to our d/b.

    i have a created a batch file for my sqlldr process to run.What i want is how can i automate this process of loading.

    Thanx
    Sushant

  2. #2
    Join Date
    Nov 2002
    Posts
    115
    Sushant,

    The simplest way wud be putting batch file in NT schedular..

    Regards,
    prasdvd@rediffmail.com
    Prasad

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You may make use of this script. I automated loading on NT machine using this batch file.
    Code:
    @ECHO OFF
    ECHO  Finding Data to be loaded...
    CD C:\DATA\
    FOR  %%V in (*.DAT) DO SQLLDR73.EXE username/password@db CONTROL=C:\CODE\PRE.CTL LOG=C:\LOG\PRE.LOG BAD=C:\LOG\PRE.BAD DATA=%%V ERRORS=1500
    MOVE *.DAT C:\OUT\
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  5. #5
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    You could consider migrating to 9i for making use of the external tables functionallity.

    Regards
    Gert

  6. #6
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Oracle has introduced an excellent feature called "External tables", where you can refer text files as Oracle tables. These file formats can be similar to the one which we use for sqlldr. For further details visit:
    http://otn.oracle.com/sample_code/pr...rnalTables.pdf
    Agasimani
    OCP(10g/9i/8i/8)

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