4 Replies Latest reply on Jul 15, 2010 12:26 PM by 766393

    several errors during bulk add (ORA-13199, ORA-12801, ORA-01652, ORA-01653)

    766393
      Hi,

      In a batch process I use a parallel bulk add to insert several millions of triples in an RDF model.
      At some point, an insert failed with this message :

      ORA-13199: Failed in DDL_same_rdf_indexes call:ORA-13199: step_num=6 SQLERRM=ORA-12801: error signaled in parallel query server P020
      ORA-01652: unable to extend temp segment by 128 in tablespace RDF dss=ALTER INDEX "RDF_LNK_SCPM_IDX" REBUILD PARTITION MODEL_63 NOLOGGING PARALLEL ONLINE ORA-06512: at "MDSYS.MD", line 1723
      ORA-06512: at "MDSYS.MDERR", line 17
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 9223
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 9428
      ORA-06512: at "MDSYS.MD", line 1723
      ORA-06512: at "MDSYS.MDERR", line 17
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 9441
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 4255
      ORA-06512: at "MDSYS.SDO_RDF", line 276
      ORA-06512: at "MDSYS.RDF_APIS", line 693
      ORA-06512: at line 1

      Since the batch process continued and tried to insert later on, I got this error twice, then another one several times :

      ORA-13199: During LBV:ORA-01653: unable to extend table MDSYS.RDF$TV_3F_1501FA303B1C4_56 by 128 in tablespace RDF ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 1319
      ORA-06512: at "MDSYS.MD", line 1723
      ORA-06512: at "MDSYS.MDERR", line 17
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 1414
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 3786
      ORA-06512: at "MDSYS.SDO_RDF", line 276
      ORA-06512: at "MDSYS.RDF_APIS", line 693
      ORA-06512: at line 1

      Finally, later on, the bulk insert worked with no error. I haven't had any kind of similar errors since.

      Any idea what could have caused this ?

      Thanks,

      Regards,
      Julien