OraFAQ Forum: Server Utilities » Default file location in SQL* Loader

Home » RDBMS Server » Server Utilities » Default file location in SQL* Loader

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Default file location in SQL* Loader [message #168578]

Fri, 21 April 2006 01:06

gajini
Messages: 262
Registered: January 2006

Senior Member

If i invoke the SQL* Loader,using the following command

SQLLDR system/manager CONTROL=LOAD1.CTL LOG=LOAD1.LOG
BAD=LOAD1.BAD DISCARD=LOAD1.BAD

what will be the default location for the files,LOAD1.CTL,LOAD1.LOG,LOAD1.BAD,LOAD1.BAD?

Thanks,
Malru

Report message to a moderator

Re: Default file location in SQL* Loader [message #168615 is a reply to message #168578]

Fri, 21 April 2006 04:15

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

"Will be" is wrong term regarding "load1.ctl" control file as it should already exist somewhere, unless you want this command to fail before it starts.

As of other files, working directory is the default location.

Report message to a moderator

Re: Default file location in SQL* Loader [message #169136 is a reply to message #168578]

Tue, 25 April 2006 04:36

srikanth_hans
Messages: 8
Registered: April 2006

Junior Member

I think you should place the control file in the directory from where you are invoking the loader utility.
so that will be the directory where all the other files i mean to say .log,.dsc.bad file will be stored.

hope this will help you.

Report message to a moderator

Previous Topic:	SQL*Loader and .bat files
Next Topic:	Want to reject rows with NULL values in particular column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 16 05:26:35 CDT 2025