Hi,
my source database is 11gR2 (11.2.0.4) with the latest PSU patches applied on IBM AIX 7.1 operating system
my destination database is 12cR(12.1.0.2) with latest PSU patches applied on Linux Red Hat 7.4 operating system
I have performed a successful export datapump from the source database with NO errors in the log file. when I imported the dump in the destination database the below errors were thrown
(please note that I have perform impdp using SYS account)
ORA-39083: Object type
INDEXTYPE:"SDE"."ST_SPATIAL_INDEX" failed to create with
error:
ORA-29829: implementation
type does not exist
Failing sql is:
CREATE INDEXTYPE
"SDE"."ST_SPATIAL_INDEX" FOR
"SDE"."ST_BUFFER_INTERSECTS"
("SDE"."ST_GEOMETRY",
"SDE"."ST_GEOMETRY", NUMB
ER),
"SDE"."ST_CROSSES" ("SDE"."ST_GEOMETRY",
"SDE"."ST_GEOMETRY"),
"SDE"."ST_ENVINTERSECTS"
("SDE"."ST_GEOMETRY", NUMBER,
NUMBER, NUMBER, NUMBER),
"SDE"."ST_ENVINTERSECTS"
("SDE"."ST_GEOMETRY",
"SDE"."ST_GEOMETRY", VARCHAR2),
"SDE"."ST_ENV
Processing object type
DATABASE_EXPORT/SCHEMA/INDEXTYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-39112: Dependent
object type OBJECT_GRANT:"SDE" skipped, base object type
INDEXTYPE:"SDE"."ST_SPATIAL_INDEX" creation f
ailed
Failing sql is:
ASSOCIATE STATISTICS WITH
TYPES "SDE"."ST_GEOMETRY" USING "SDE"."ST_DOMAIN_STATS"
ORA-39112: Dependent
object type ASSOCIATION skipped, base object type
INDEXTYPE:"SDE"."ST_SPATIAL_INDEX" creation failed
ORA-39083: Object type
ASSOCIATION failed to create with error:
ORA-29820: the statistics
type is not present
any help will be appreciated.
Thanks,