Invoking Sql*Loader!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Invoking Sql*Loader!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi all!

    Query:

    1.What is the command to invoke sql*loader on WINNT with Oracle v8i.

    After sql*loader is invoked,it asks for Control File,Lof file names.

    Does it mean to mention the DB control files,Redo Log files with their complete path names when prompted!I have not used this before.

    2.What is the command to insert records into tables through
    sql*loader both direct and conventional paths please!

    Regards,

    Amitstora.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by amitstora
    1.What is the command to invoke sql*loader on WINNT with Oracle v8i.
    C:\> sqlldr

    After sql*loader is invoked,it asks for Control File,Lof file names.

    Does it mean to mention the DB control files,Redo Log files with their complete path names when prompted!I have not used this before.
    No, database control and redolog files have nothing to do with sqlldr's contol and log files! Sqlldr's controlfile (you should create one before each load) defines what stuff are you trying to load, where are you trying to load this stuf into and how are you trying to load this stuff.

    2.What is the command to insert records into tables through
    sql*loader both direct and conventional paths please!
    It is a little more than just a sibgle command! Almost an entire manual book is devoted to SQL*Loader! You can start here: http://otn.oracle.com/docs/products/...rt2.htm#435958
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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