OraFAQ Forum: Server Utilities » SQL*Loader for XP won't Load

Home » RDBMS Server » Server Utilities » SQL*Loader for XP won't Load

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

SQL*Loader for XP won't Load [message #132392]

Fri, 12 August 2005 08:40

alland
Messages: 3
Registered: August 2005

Junior Member

Hello, I'm a newbie and am trying to learn to load data into an Oracle table. I've looked at the documentation, and tahiti and I am unable to load data.

The Table, Test1, consists of one field, State. My instance is called Test.

The data file looks like this:

"NJ",

The control file looks like this:

LOAD DATA
INFILE 'c:\mystates.csv'
INTO TABLE TEST1
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(STATE CHAR)

The command line looks like this:

sqlldr userid=system/allan1@TEST control=C:\mystates.ctl

{I'm running this using Start-->Run
in Windows XP.)

Thanks in advance.

Report message to a moderator

Re: SQL*Loader for XP won't Load [message #132394 is a reply to message #132392]

Fri, 12 August 2005 08:46

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

sql*loader ctl file should work the same for windows.

oracle@mutation#cat a.ctl
LOAD DATA
infile 'a.data'
insert INTO TABLE a  FIELDS TERMINATED BY "," optionally enclosed by '"' trailing nullcols
(
state
)
oracle@mutation#desc mutation scott.a

Table:scott.a
 Name                                Null?    Type
 ----------------------------------- -------- ------------------------
 STATE                                        VARCHAR2(2)

oracle@mutation#cat a.data
"NJ",
oracle@mutation#sqlldr userid=scott/tiger control=a.ctl

SQL*Loader: Release 9.2.0.4.0 - Production on Fri Aug 12 09:47:29 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 1
oracle@mutation#query mutation scott.a

ST
--
NJ

Report message to a moderator

Re: SQL*Loader for XP won't Load [message #132435 is a reply to message #132392]

Fri, 12 August 2005 13:49

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

Senior Member

If you are going to run it using start and run, then you need to include the full path for your sqlldr.exe file, which should be in the bin subdirectory of your oralce home directory. For example, my oracle home directory is d:\oracle\ora92, so my command line, using the scott schema, would be:

d:\oracle\ora92\bin\sqlldr userid=scott/tiger control=c:\mystates.ctl

Report message to a moderator

Re: SQL*Loader for XP won't Load [message #132448 is a reply to message #132435]

Fri, 12 August 2005 16:06

alland
Messages: 3
Registered: August 2005

Junior Member

Thanks Barbara and Mahesh. Using your input, I am now good to go!! Your assistance is GREATLY appreciated.

Report message to a moderator

Previous Topic:	user define parameters to SQL Loader.
Next Topic:	sqlloader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 19:19:38 CST 2024