Re: script for sqlldr
- From: Adam Musch <ahmusch@xxxxxxxxx>
- To: s.cislaghi@xxxxxxxxx
- Date: Thu, 1 Apr 2010 15:51:50 -0500
Generally, that's only required if you're doing a TRUNCATE operation
or running SQL*Loader in direct path mode. So the problem could be in
the run time arguments, the parameter file, or the control file.
On Thu, Apr 1, 2010 at 3:00 PM, Stefano <s.cislaghi@xxxxxxxxx> wrote:
> 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
>
> ________________________________
> From: "Zelli, Brian" <Brian.Zelli@xxxxxxxxxxxxxxx>
> Date: Thu, 1 Apr 2010 15:44:54 -0400
> 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.
--
Adam Musch
ahmusch@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
