Home » Infrastructure » Windows » Problem In SQL* Loader with Win2000 Professional
Problem In SQL* Loader with Win2000 Professional [message #119811] Mon, 16 May 2005 01:01 Go to next message
sachin2mail
Messages: 4
Registered: March 2005
Location: Hyderabad
Junior Member
Hi,

I am working on convertion of database from different database to oracle. I am using oracle 8i, sql Loader with win 2000 professional to load the data in oracle. The syntax to load data is (c:\>sqlldr system/manager@scs party.ctl) in command prompt. After loading data, loader creates log files, bad files if any, but loader does not getting terminated from the command prompt I have to press ^C (Ctrl+C) to come out from the prompt. I have to load 200 tables, so am using .Bat file in which I have written all the loader command. Than also I am getting the same problem. If any body is having any Idea, help me.

bye
sachin
Re: Problem In SQL* Loader with Win2000 Professional [message #119927 is a reply to message #119811] Mon, 16 May 2005 14:15 Go to previous message
Mahesh Rajendran
Messages: 10703
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>The syntax to load data is (c:\>sqlldr system/manager@scs party.ctl) in command prompt

The syntax should be
sqlldr system/manage@scs control=party.ctl

There might be some problem with the bat file.
Please Post the relevant data from logfiles.
Previous Topic: Oracle 10g Enterprise Manager Language Setting
Next Topic: Problem connect oracle db with vb via odbc
Goto Forum:
  


Current Time: Mon Aug 08 21:42:48 CDT 2022