Home » RDBMS Server » Server Utilities » Problem with sqlloader
Problem with sqlloader [message #69508] Wed, 23 January 2002 09:25 Go to next message
Godwin
Messages: 37
Registered: January 2002
Member
Please can anyone help me!
I have my text file saved in Notepad as
'mydata.txt' and contains
10018506,2001,"1",80
10018507,2001,"2",65
I then create a control file as
'control.ctl'
load data
infile 'c:mydata.txt'
append
into table_a (iahstno,iahcyr,iahbc,iahexm1)
Now after i have run the sqlldr at the DOS prompt as
c:ora95po>sqlldr dpc/stud control ='c:control.ctl'
I recieved the message that '2 logical records commited'
But after i logged on to the sql environment and select
all the rows from table table_a, i didn't get the actual records in the mydata.txt file, instead i had in the table the ff records:
1 0 0 0
1 0 0 0
what is cause of the above? Or is there a better steps to follow since i followed FAQ step by step Oracle SQL*Loader.

My second question is that i called an sql procedure in a form so that it will select records from a different table into another after which it should commit it. Although the procedure runs successfully,i have a problem such that anytime i close the form the message comes up that 'do u want to save changes' and if i accept Yes the error comes that it is unable to save changes.
Is there a way out?
Re: Problem with sqlloader [message #69527 is a reply to message #69508] Sun, 27 January 2002 09:23 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
you have to specify fields terminated by ',' optionally enclosed by '"' in control file.

I think you are missing that...
Previous Topic: Re: OCP Exam Papers
Next Topic: Load from different files to one table
Goto Forum:
  


Current Time: Wed Feb 28 19:04:21 CST 2024