Re: script for sqlldr

  • From: "Stefano" <s.cislaghi@xxxxxxxxx>
  • To: Brian.Zelli@xxxxxxxxxxxxxxx,"oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 1 Apr 2010 20:00:52 +0000

Hello Brian,

May u post your script? BTW last line is your problem. Sqlloader have to lock a 
table and is not able to do it maybe due to anothe transaction. Check for any 
locks on the object related.

Stefano


--
http://www.stefanocislaghi.eu

Sent by BlackBerry® Bold 9700

-----Original Message-----
From: "Zelli, Brian" <Brian.Zelli@xxxxxxxxxxxxxxx>
Date: Thu, 1 Apr 2010 15:44:54 
To: oracle-l-freelists<oracle-l@xxxxxxxxxxxxx>
Subject: script for sqlldr

I am trying to test a script for sqlloader and get this error:

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

ORA-00604: error occurred at recursive SQL level 1

ORA-00054: resource busy and acquire with NOWAIT specified

Oracle 10g on HPUX.  Googling didn't offer much help.

Brian




This email message may contain legally privileged and/or confidential 
information.  If you are not the intended recipient(s), or the employee or 
agent responsible for the delivery of this message to the intended 
recipient(s), you are hereby notified that any disclosure, copying, 
distribution, or use of this email message is prohibited.  If you have received 
this message in error, please notify the sender immediately by e-mail and 
delete this email message from your computer. Thank you.

Other related posts: