-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|