Home » RDBMS Server » Server Administration » ORA-39778
ORA-39778 [message #298499] Wed, 06 February 2008 04:23 Go to next message
arunprasad_bh
Messages: 32
Registered: June 2007
Member
Hi, I am getting ORA-39778 while using informatica bulk load option for loading clob columns. We did use this in 9.2.0.5. Then we upgraded to 9.2.0.8 and now to 10.2.0.3.0. In both the environments I am not been able to use bulk load facility. Following document does say it is an Oracle bug and a patch is available(3931084).
http://download.oracle.com/docs/cd/B14100_14/relnotes.1012/relnotes/install.htm

But it we are already on higher versions and also this patch is applied.

Please advise if there are any parameters that I can change to get this bulk loading achieved for clob columns.

I have attached error in a text file.

Thanks
Aruna
  • Attachment: error.log
    (Size: 1.14KB, Downloaded 1175 times)
Re: ORA-39778 [message #298512 is a reply to message #298499] Wed, 06 February 2008 04:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Are you sure your error comes from this bug?
What do you make you think this is the case?
Generally speaking:
ORA-39778: the parallel load option is not allowed when loading lob columns
 *Cause:   An attempt was made to load lob columns using the attribute
           OCI_ATTR_DIRPATH_PARALLEL. This error will also be issued when
           loading any columns that are stored as lobs (such as varrays and
           xml types).
 *Action:  Do not use the parallel attribute when loading lob columns.

Regards
Michel
Re: ORA-39778 [message #298526 is a reply to message #298499] Wed, 06 February 2008 05:07 Go to previous messageGo to next message
arunprasad_bh
Messages: 32
Registered: June 2007
Member
Because we used this facility in 9.2.0.5 without any issues.
After upgrade to later versions only we have experienced this problem.
It may be due to this bug or because of change in any other parameters. We used bulk load to load clob columns for more than six months before version upgrades. After upgrades, we inherited this problem.
Re: ORA-39778 [message #298557 is a reply to message #298499] Wed, 06 February 2008 06:39 Go to previous messageGo to next message
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
Member
Your case appears to be an OCI call level incompatibility issue.
Please Checkup with informatica if your version of informatica is compatible with 10gR2. There are changes in OCI functionality from 9i to 10g. I have seen some older OCI applications behaving strangely in 10g.

Regards

Manjit Kumar[mkbhati]

[Updated on: Wed, 06 February 2008 06:42]

Report message to a moderator

Re: ORA-39778 [message #298720 is a reply to message #298499] Thu, 07 February 2008 05:53 Go to previous messageGo to next message
arunprasad_bh
Messages: 32
Registered: June 2007
Member
I think it is causing an issue because it is trying to load in parallel in bulk mode. Oracle stopped supporting parallel load of lobs since 9.2.0.5(some dba's quote. not mine)

So is there any way we can force not parallel from oracle side when using bulk loading?

The table in question is already in NOPARALLEL mode.
Re: ORA-39778 [message #299023 is a reply to message #298720] Fri, 08 February 2008 11:42 Go to previous message
arunprasad_bh
Messages: 32
Registered: June 2007
Member
Found the issue.
It is causing problem because after 9.2.0.5 oracle stopped supporting parallel load for lob columns. And Informatica connection by default uses parallel load for bulk load. After I changed the connection to not using parallel, the load was successful.
Previous Topic: How can i see the table space of a user
Next Topic: rollback and tablespace space usage
Goto Forum:
  


Current Time: Wed Nov 13 00:02:57 CST 2024