Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Datapump and Oracle Spatial (11.1.0.7 -> 10.2.0.1)

773621May 18 2010 — edited May 18 2010
Hi all,

I want to export a schema with expdp from a 11g database and import the created file to 10g database with impdp.
my export-commandline is as follow:

expdp system/***@db_01 schemas=grnfl directory=data_dump exclude=statistics logfile=grnfl.log reuse_dumpfiles=y version=10.2.0.1

with the version-parameter it is possible to import the file to 10g database.
I tried to import with:

impdp system/***@db_02 dumpfile=expdat.dmp logfile=grnfl_imp.log


there are no problems with all my tables without mdsys.sdo_geometry. but the tables with spatial are not imported with error-messages in logfile:

-----
ORA-31693: Tabellendatenobjekt "GRNFL"."ANLAGE" konnte nicht geladen/entladen werden und wird wegen Fehler übersprungen:
ORA-02354: Fehler beim Exportieren/Importieren von Daten
ORA-39779: type "MDSYS"."SDO_GEOMETRY" not found or conversion to latest version is not possible
-----

with old imp/exp I was able to add a parameter toid_novalidate to import dumpfiles from 11g database into 10g database.

Any idea what I can do to import mdsys.sdo_geometry correct?

Many Thanks,
Daniel

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 15 2010
Added on May 18 2010
#11g, #database-key-features, #export-import-sql-loader-external-tables, #spatial
1 comment
2,751 views