Home » SQL & PL/SQL » SQL & PL/SQL » ORA-39775: direct path API commit not allowed due to previous fatal error (Oracle 10g)
ORA-39775: direct path API commit not allowed due to previous fatal error [message #357884] Fri, 07 November 2008 00:49 Go to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,

While running the run batch Xml , the below error throws


[exec] SQL*Loader-926: OCI error while uldlm:OCIDirPathFinish for table XXXX
     [exec] ORA-39775: direct path API commit not allowed due to previous fatal error
     [exec] SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

     [exec] SQL*Loader: Release 9.2.0.4.0 - Production on Thu Nov 6 20:59:54 2008


I need to know why this happens and any solution for this

Thanks in Advance
Re: ORA-39775: direct path API commit not allowed due to previous fatal error [message #357895 is a reply to message #357884] Fri, 07 November 2008 01:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It happens
Quote:
due to previous fatal error

that you didn't post.
Have a look at your batch log.

Regards
Michel
Re: ORA-39775: direct path API commit not allowed due to previous fatal error [message #357906 is a reply to message #357895] Fri, 07 November 2008 02:49 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,

No error has occured but it tires to delete and again insert into table ,but count so now vlues has been inserted (ie) count is 0

what do u mean for the below error

 SQL*Loader-926: OCI error while uldlm:OCIDirPathFinish for table XXXXX


As of google search says its the problem occurs over undo process

Is this correct and any other fix for this if means pls guide me reg this

Thanks,
Re: ORA-39775: direct path API commit not allowed due to previous fatal error [message #357908 is a reply to message #357906] Fri, 07 November 2008 02:52 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Have a look at your batch log.

And post Loader log.

Regards
Michel
Previous Topic: pls help
Next Topic: Query based on the other query data
Goto Forum:
  


Current Time: Mon Dec 05 23:58:05 CST 2016

Total time taken to generate the page: 0.10804 seconds