OraFAQ Forum: Server Utilities » using sql plus and ctl file

Home » RDBMS Server » Server Utilities » using sql plus and ctl file

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

using sql plus and ctl file [message #73851]

Sun, 25 July 2004 22:38

pat
Messages: 27
Registered: September 2000

Junior Member

Hi,

How can i use sql plus to run my .ctl file?

Thanks!

�

Report message to a moderator

Re: using sql plus and ctl file [message #73852 is a reply to message #73851]

Sun, 25 July 2004 23:10

Barbara Boehmer
Messages: 9101
Registered: November 2002
Location: California, USA

Senior Member

host sqlldr username/password control=your_control.ctl

Report message to a moderator

Re: using sql plus and ctl file [message #73858 is a reply to message #73852]

Mon, 26 July 2004 15:47

pat
Messages: 27
Registered: September 2000

Junior Member

Hi,

I've tried using the command :
host sqlldr username/password control=your_control.ctl
The MS DOS prompt did appear, but the table is still unpopulated. Please advise.

Report message to a moderator

Re: using sql plus and ctl file [message #73863 is a reply to message #73858]

Tue, 27 July 2004 04:56

Barbara Boehmer
Messages: 9101
Registered: November 2002
Location: California, USA

Senior Member

Try adding a log file, then see what it says there:

host sqlldr scott/tiger control=your_control.ctl log=your_log.log

edit your_log.log

If you need more help, please post your control file, table structure, and contents of your log file here.

Report message to a moderator

Re: using sql plus and ctl file [message #73868 is a reply to message #73863]

Tue, 27 July 2004 15:08

pat
Messages: 27
Registered: September 2000

Junior Member

Thanks!

Report message to a moderator

Previous Topic:	database Import related query
Next Topic:	very Urgent Help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 08:31:07 CST 2024