| Loading control file in SQL loader [message #185115] |
Mon, 31 July 2006 01:31  |
Ramnath
Messages: 7
Registered: July 2006
|
Junior Member |
|
|
I have a control file to parse an input file.
Iam using Unix(AIX) with oracle client installed in it.
Now where do i need to place the control file?
how to run and check it?
|
|
|
|
| Re: Loading control file in SQL loader [message #185135 is a reply to message #185115] |
Mon, 31 July 2006 02:24  |
 |
Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
SQL*Loader is the command prompt utility. It is run like this:
> sqlldr userid=scott/tiger@ora8 control=control_file.ctl log=loader.log
Utility name changes between different Oracle versions, so yours might not be SQLLDR.
Read more about SQL*Loader on the Oracle Technology Network; can't open the page at the moment to get you link to the SQL*Loader utility, but I believe you'll be able to find it yourself.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
