IMPDP Throws ORA-31685

(Doc ID 2160915.1)

Last updated on APRIL 05, 2018

Applies to:

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

Symptoms

Loading spatial indexes using impdp fails with:

ORA-31685: Object type INDEX:"SUOMI4_VSA"."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 != 'SUOMI4') ) 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 != 'SUOMI4') ) 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

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