Home » RDBMS Server » Server Utilities » Loading control file in SQL loader
Loading control file in SQL loader [message #185115] Mon, 31 July 2006 01:31 Go to next message
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 Go to previous message
Messages: 20849
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.
Previous Topic: How to distinguish b/w normal trace file and different Sessions enabled SQL trace files?
Next Topic: exporting database objects without tables
Goto Forum:

Current Time: Sat Oct 22 08:51:39 CDT 2016

Total time taken to generate the page: 0.12550 seconds