ORA-39779 TRYING TO USE 10.2.0.3.0 EXPDP/IMPDP UTILITY FROM 11G DATABASE TO 10.2 (Doc ID 740718.1)

Last updated on NOVEMBER 19, 2008

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.1.0.7
This problem can occur on any platform.

Symptoms

@TAR 18401898.6

Trying to perform an expdp from an 11g database and then impdp to 10g database.


Using 10g utilities, data is exported from 11g database:
expdp DIRECTORY=EXP_DUMP_DIR DUMPFILE=exp_oracle11_test.dmp
logfile=exp_oracle11_test.log tables=tab1 version=10.2
.
Attempt to import data into 10g database:
impdp DIRECTORY=EXP_DUMP_DIR DUMPFILE=exp_oracle11_test.dmp
logfile=imp_oracle11_test.log tables=tab1 TRANSFORM=OID:N

Get the following errors on impdp : 
Import: Release 10.2.0.3.0 - Production on Thursday, 17 January, 2008 10:12:47
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
Master table "SYSTEM"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TABLE_01": system/******** DIRECTORY=
bala_test_dir DUMPFILE=exp_oracle11_test.dmp logfile=imp_oracle11_test.log tables=bala.tab1 TRANSFORM=OID:N
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "BALA"."TAB1" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-39779: type "MDSYS"."SDO_GEOMETRY" not found or conversion to latest version is not possible
Job "SYSTEM"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 10:13:00

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