Invoking Sql*Loader!

[amitstora]

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.

[jmodic]

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