Home » RDBMS Server » Server Utilities » SQL LOADER PROBLEM, PLZ HELP ME!
SQL LOADER PROBLEM, PLZ HELP ME! [message #236363] Wed, 09 May 2007 13:53 Go to next message
Basit
Messages: 38
Registered: April 2007
Member

Hi
This is basit, plz help me out to solve this! this a polite
request to you all! I have problem with SQL LOADER, let me
tell you the step i follow,

1: $sqlldr scott/tiger control=loader.ctl
Then a black window opens and disapears and nothing
happens.
2:i have a control file named LOADER.ctl, which is like this,

load data
infile 'c:\emp2.csv'
into table emp1
fields terminated by "," optionally enclosed by '"'
( comm, deptno, employee_id, ename, hiredate, job, mgr, sal )

3: But don't know where to place this file. plz kindly tell
where to place this control file? i mean which folder or
drive?

4: i have a file to be loaded in my table in database.
File is a MS EXCEL file and i have changed it into CSV
format. File name is EMP2.CSV

i had been try for 4 dayz but still not successful !
help me b'coz i m like this now :-<
i m waiting for you positive response.

regards
Basit Samar
Re: SQL LOADER PROBLEM, PLZ HELP ME! [message #236366 is a reply to message #236363] Wed, 09 May 2007 14:39 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
visit http://tahiti.oracle.com & read the UTILITIES Manual on proper use of SQL*Loader utility.

I need to stop multiplexing or pay closer attention to what I am typing.

[Updated on: Wed, 09 May 2007 15:54] by Moderator

Report message to a moderator

Re: SQL LOADER PROBLEM, PLZ HELP ME! [message #236377 is a reply to message #236366] Wed, 09 May 2007 15:07 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I believe you meant SQL*Loader utility, not Import. Right?
Previous Topic: how to access a log file and a bad file?? (merged across forums)
Next Topic: PO Receipts Conversion
Goto Forum:
  


Current Time: Thu Dec 08 16:40:53 CST 2016

Total time taken to generate the page: 0.11023 seconds