Hi,
I am trying to import a table from an Oracle 11gR2 database (11.2.0.3) to an Oracle 12cR1 (12.1.0.2) database (non-CDB).
Here is how I have done the export from the source:
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string ZEUS
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
parfile: exp_missing_SPATIAL_SCHEMAS_ZEUS11g.par
tables=MANGO.ORTHO_PHOTOS,MVDEMO_NATURALEARTH.WORLD_RASTER
directory=DATA_PUMP_DIR
reuse_dumpfiles=y
exclude=statistics
dumpfile=expdp_missing_SPATIAL_SCHEMAS_ZEUS11g.dmp
logfile=logexpdp_missing_SPATIAL_SCHEMAS_ZEUS11g.log
expdp system parfile=exp_missing_SPATIAL_SCHEMAS_ZEUS11g.par
Here is how I have done the import to the target:
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string ZEUS
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production
parfile: imp_missing_SPATIAL_SCHEMAS_ZEUS12c.par
tables=MANGO.ORTHO_PHOTOS,MVDEMO_NATURALEARTH.WORLD_RASTER
directory=TEMP_DUMPS
dumpfile=expdp_missing_SPATIAL_SCHEMAS_ZEUS11g.dmp
logfile=logimpdp_missing_SPATIAL_SCHEMAS_ZEUS12c.log
impdp system parfile=imp_missing_SPATIAL_SCHEMAS_ZEUS12c.par
I end up with this sort of error:
ORA-39117: Type needed to create table is not included in this operation. Failing sql is:
CREATE TABLE "MANGO"."ORTHO_PHOTOS" ("FID" NUMBER, "NAME" VARCHAR2(256 BYTE), "TYPE" VARCHAR2(256 BYTE), "IMAGE" "MDSYS"."SDO_GEORASTER" )
SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE ...
Yet, the "MDSYS"."SDO_GEORASTER" data type exist in both the source and target database.
Does someone have such experience, is it maybe related to a bug?
Thanks by advance for any tip.
Kind Regards