IMPDP Throws ORA-31685
(Doc ID 2160915.1)
Last updated on AUGUST 26, 2020
Applies to:
Oracle Spatial and Graph - Version 12.1.0.2 and laterInformation in this document applies to any platform.
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
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 |
Changes |
Cause |
Solution |
References |