View Full Version : Problem in Sql Loader With Win2000 professional
Kevin Golding via DBMonster.com
05-11-2005, 01:18 AM
Hi,
I am using Win-2000 prof. while loading data with sqlldr I am not
getting terminated from the prompt after inserting all the data in the
table.
c:\>sqlldr system/manager@scs party.ctl silent=HEADER --enter
^c
c:\>
I have to press Ctrl+C to come out from the prompt.
After Loading the data in table, Sqlldr creates log files, or bad file if
any. I press Enter key many times, instead of ^C than also it does not do
any thing, only it wait over there. After pressing ^c it will preform the
task, what ever the command we have given while it was in Hanging
condition. This same condition is also with Batch files. I have to load
nearly 200 tables data so I used batch file for that. I got this problem
with batch files and when I tried with single command, the problem was
same.
help me
Użytkownik Sachindra Kumar Meshram via DBMonster.com napisał:
Hi, I am using Win-2000 prof. while loading data with sqlldr I am not getting terminated from the prompt after inserting all the data in the table. c:\>sqlldr system/manager@scs party.ctl silent=HEADER --enter
try c:\>sqlldr system/manager@scs control=party.ctl silent=HEADER,
or remove silent hint.
--
Noel
Booker Mpando via DBMonster.com
05-11-2005, 08:38 PM
Thanks For Reply,
But I tried with that, it is not working. I have posted this same question
in few more forumes but no body got the answere. I thought to post it with
AskTom/oracle.com but, I was unable. Can u give me some more suggestion.
bye
--
Message posted via http://www.dbmonster.com
Rauf Sarwar
05-12-2005, 12:43 AM
Sachindra Kumar Meshram via DBMonster.com wrote: Thanks For Reply, But I tried with that, it is not working. I have posted this same
question in few more forumes but no body got the answere. I thought to post it
with AskTom/oracle.com but, I was unable. Can u give me some more
suggestion. bye -- Message posted via http://www.dbmonster.com
Try this,
sqlldr user/pwd@db control=file.ctl bad=file.bad log=file.log
If you still run into issues then post your control file.
Regards
/Rauf
MyLounge.com Site Map
Forum:
Cars,
Cell Phone,
Database,
Games,
Home Improvement,
IT,
Music,
School,
Sports,
Web Design,
Web Server,
Weight Loss
The MyLounge.com forum is intended for informational use only and should not
be relied upon and is not a substitute for any advice. The information contained
on MyLounge.com are opinions and suggestions of members and is not a representation
of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for
the accuracy, completeness or usefulness of any postings or the qualifications
of any person responding. Please consult a expert or seek the services of an
attorney in your area for more accuracy on your specific situation. Please note
that our forums also serve as mirrors to Usenet newsgroups. Many posts you see
on our forums are made by newsgroup users who may not be members of MyLounge.com
Term of Service
vBulletin v3.0.7, Copyright ©2000-2009, Jelsoft Enterprises Ltd.