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 and later
Information in this document applies to any platform.


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 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


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