ORA-01476: Divisor Is Equal To Zero When Long Literals >4000 Exist In RDF_VALUE$ (Doc ID 2004528.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

When doing the bulk load using mbv_method=shadow AND RDF_VALUE$ has long literals >4000 (using LONG_VALUE clob column)

getting error

  ORA-01476: divisor is equal to zero

truncate table LUBM_RDF_DATA2;
set timing on
alter session enable parallel dml;
exec sem_apis.bulk_load_from_staging_table ('lubm2', 'rdf_lubm', 'STAGE_TABLE', flags=>'parse mbv_method=shadow parallel=4 parallel_create_index DEL_BATCH_DUPS=USE_INSERT ');

*
ERROR at line 1:
ORA-13199: During MBV Swap: [21-MAR-15 03.05.53.634362000 AM +00:00]
ORA-12801: error signaled in parallel query server P000
ORA-01476: divisor is equal to zero [
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 3888
]
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 4107
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 6197
ORA-06512: at "MDSYS.SDO_RDF", line 707
ORA-06512: at "MDSYS.RDF_APIS", line 893
ORA-06512: at line 1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms