Urgent: Oracle Help in sqlldr - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Urgent: Oracle Help in sqlldr

Author

Topic

a_r_satish
Yak Posting Veteran

84 Posts

Posted - 2006-03-31 : 04:00:40

Plz Help Urgent(Oracle)
i am using the Vfp 5.0 for my application and using the sqlldr to load the records as bulk to the db tables.
Inputs from the notepad are correctly fetched and stored my my db table(tempcontract).

But when i use the Direct = true option, then the details are not stored.

SQL*Loader-951: Error calling once/load initialization

I studied from net that when the "Direct = True" option is used then the insertion into the db table would be faster. so i tried. but when i don provide that option, then the details are exactly loaded into my db table.

Can anyone help me in pointing out the problem.

sample :

cCommand_line ='SQLLDR.EXE CONTROL = '+TEMPDIR+'CONTROL.CTL'+' '+;
+'LOG = '+TEMPDIR+'S2K.LOG USERID ='+lcUserName+'/'+lcPassWord +'@'+;
lcDatasource + ' ROWS=1000 Direct = True '

Thanks in advance.

Regards,
satish.r
"Known is a drop, Unknown is an Ocean"

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-03-31 : 04:04:17

post your proble here:
http://www.dbforums.com/forumdisplay.php?f=4

there's not much people here that know oracle.

Go with the flow & have fun! Else fight the flow