OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-39778

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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 1164 times)

Report message to a moderator

Re: ORA-39778 [message #298512 is a reply to message #298499]

Wed, 06 February 2008 04:44

Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

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.

Report message to a moderator

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.

Report message to a moderator

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.

Report message to a moderator

Previous Topic:	How can i see the table space of a user
Next Topic:	rollback and tablespace space usage

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 05:57:56 CDT 2024