OraFAQ Forum: Server Utilities » problem to open SQLLDR

Home » RDBMS Server » Server Utilities » problem to open SQLLDR

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

problem to open SQLLDR [message #295346]

Tue, 22 January 2008 03:11

dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka

Senior Member

Dear Expeorts,

i am very new to use SQLLDR tools. i am facing the following problem, will you pls help me ?

when i type in the command prompt as :

SQLLDR scott/tiger@sdwh

and press enter a new command appears as:

Control=

my question what should i type in the Control=

or what is the other and better way to invoke SQLLDR and get in for its operation?

Thank you,
-------------------
Kamal Hossain

Report message to a moderator

Re: problem to open SQLLDR [message #295347 is a reply to message #295346]

Tue, 22 January 2008 03:13

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

When it offer control give the control file name. In one line you can invoke all of the commands.

For more,

sqlldr help=y

Report message to a moderator

Re: problem to open SQLLDR [message #295349 is a reply to message #295346]

Tue, 22 January 2008 03:15

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Database Utilities
Part II SQL*Loader

Regards
Michel

Report message to a moderator

Re: problem to open SQLLDR [message #295352 is a reply to message #295346]

Tue, 22 January 2008 03:20

dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai

Senior Member

control file gives information about data,ie how to interpret your data,where to load your data.

you can also refer to the doc below.

SQLLDR

[edit : a bit late in posting]

regards,

[Updated on: Tue, 22 January 2008 03:22]

Report message to a moderator

Previous Topic:	ORA-27369: job of type EXECUTABLE failed with exit code: Not owner
Next Topic:	Deleting Orphans After Export

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 15:35:34 CDT 2024