After A Transportable Tablespace Operation Inserting Into Georaster Table ORA-13401: Duplicate Entry For RASTER_DATA_TABLE_01 In USER_SDO_GEOR_SYSDATA View (Doc ID 981284.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version: 10.2.0.4 to 11.2.0.1 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

After a transportable tablespace operation inserting into georaster table you receive error:

ORA-13401: duplicate entry for SCOTT.RASTER_DATA_TABLE_01 in USER_SDO_GEOR_SYSDATA view

Your application to load georaster may show the error with this format:

[ERROR]: LOADER OUTPUT: ORA-13401: duplicate entry for SCOTT.RASTER_DATA_TABLE_01 in USER_SDO_GEOR_SYSDATA view
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_GEOR_DEF", line 123
ORA-06512: at "MDSYS.SDO_GEOR_INT", line 2541
ORA-06512: at "MDSYS.SDO_GEOR_AUX", line 34
ORA-06512: at "SCOTT.GRDMLTR_605619_3", line 1
ORA-04088: error during execution of trigger 'SCOTT.GRDMLTR_605619_3'

Changes

Insert after a transportable tablespace operation containing Georaster tables.

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