Hello,
we try to migrate a tablespace from database 10g to 12g. The 12g has already holding tablespaces for another application.
Now we want to migrate the 10g tablespace from another application to the 12g server too.
We have made a full export with impdp without errors.
expdp system/*** DIRECTORY=mydump full=Y LOGFILE=full_export_orabeo.log JOB_NAME=full_beo DUMPFILE=FULL_EXPORT_ORABEO.dmp FLASHBACK_TIME=\"TO_TIMESTAMP(TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS')\"
Then use impdp with a parfile to import the needed tablespace:
JOB_NAME=import_expowin
INCLUDE=TABLESPACE:"like '%_TS_0'"
DIRECTORY=DATA_PUMP_DIR
LOGFILE=import_expowin.log
DUMPFILE=FULL_EXPORT_ORABEO.dmp
REMAP_DATAFILE="'F:\ORABEO\EXPODAT.ORA':'D:\ORADATA\EXPOWIN\EXPODAT.ORA'"
REMAP_DATAFILE="'F:\ORABEO\EXPOIND.ORA':'D:\ORADATA\EXPOWIN\EXPOIND.ORA'"
No errors occuerd, the tablespace are created and the datafiles have ~same size of the original datafiles. I even can login with the owner of the tablespace/schema, i can see synomyms.
But i cant see any table that should exists in the tablespace. They are also not imported in another tablespace.
Is the parfile wrong? Or must this be done in more than one imports?
After reading the docs i expected they should be there:
"Tablespace Mode
A tablespace-mode import is specified using the TABLESPACES parameter. In tablespace mode, all objects contained within the specified set of tablespaces are loaded, along with the dependent objects. The source can be a full, schema, tablespace, or table-mode export dump file set or another database. For unprivileged users, objects not remapped to the current schema will not be processed."
Can someone show me my error or a link to a more clear documentation.
Sincerly