My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.