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 APRIL 01, 2020

Applies to:

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


An error is raised when doing a bulk load using mbv_method=shadow AND RDF_VALUE$ has long literals >4000 (using LONG_VALUE clob column)

  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




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

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