IMPDP Throws ORA-31685 (Doc ID 2160915.1)

Last updated on APRIL 08, 2022

Applies to:

Symptoms

Loading spatial indexes using impdp fails with:

ORA-31685: Object type INDEX:"..."."I#ADDROBJ#GEOMETRY" failed due to insufficient privileges. Failing sql is:
BEGIN
declare
schema_name varchar2(200);
begin
select sys_context('userenv', 'CURRENT_SCHEMA') into schema_name from dual;
if ( (schema_name != user) or
  (schema_name != '....') ) then
 mdsys.sdo_meta.change_all_sdo_geom_metadata(schema_name, 'ADDROBJ','GEOMETRY',mdsys.SDO_dim_array(MDSYS.SDO_DIM_ELEMENT('X','2600000','4100000','1'),MDSYS.SDO_DIM_ELEMENT('Y','6600000','790000
ORA-31685: Object type INDEX:"SUOMI4_VSA"."I#AREA#POLYGONPOINTS" failed due to insufficient privileges. Failing sql is:
BEGIN
declare
schema_name varchar2(200);
begin
select sys_context('userenv', 'CURRENT_SCHEMA') into schema_name from dual;
if ( (schema_name != user) or
  (schema_name != '....') ) then
 mdsys.sdo_meta.change_all_sdo_geom_metadata(schema_name, 'AREA','POLYGONPOINTS',mdsys.SDO_dim_array(MDSYS.SDO_DIM_ELEMENT('X','0','1000000','1'),MDSYS.SDO_DIM_ELEMENT('Y','0','1000000','1'))
Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" completed with 2 error(s) at 13:07:16

Changes

Cause

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