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

Report message to a moderator

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: 10708
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.

Report message to a moderator

Previous Topic: Oracle 10g Enterprise Manager Language Setting
Next Topic: Problem connect oracle db with vb via odbc
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 03:42:40 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.