Error using bulk loader

610533 Jun 2, 2008 8:08 AM

HI There.
I have currently loaded many millions of triples via the bulk laoder.

I tried to load 50 million triples last week. It ran for two days and then threw the error

ERROR at line 1:
ORA-13199: APP-Load:CODE=-30036
ORA-6512: at "MDSYS.SDO_RDF_INTERNAL", line 2342
ORA-6512: at "MDSYS.SDO_RDF" line 294
ORA-6512: at "MDSYS.RDF_APIS", line 542
ORA-6512: at line 1

I'm using Oracle 11g with the jena patch applied.
This is the first time I've had a problem.
All tablespaces are on auto extend and there is plenty of disk sapce left.

Could you tell me the likely causes of the problem.

Cheers

Phil

1. Re: Error using bulk loader

Sdas-Oracle Jun 4, 2008 12:41 AM (in response to 610533)

Are there any indexes and/or additional triggers defined on the application table?
If so, that can affect bulk-load performance.
Like Show 0 Likes(0)

Actions
2. Re: Error using bulk loader

610533 Jun 4, 2008 10:43 AM (in response to Sdas-Oracle)

Hi There

There are no indexes on the data or triggers.

It is the error I am more worried about not the speed.
What is the most likely cause of the error?
Cheers

Phil
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.