ORA-39778 [message #298499] |
Wed, 06 February 2008 04:23 |
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 #298526 is a reply to message #298499] |
Wed, 06 February 2008 05:07 |
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 |
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 |
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 |
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.
|
|
|