Hi all.
Source is Oracle 10.2.0.5 on Solaris.
Destination is 12.1.0.2 on Oracle Linux.
I am trying to export and import 3 tablespaces.
on the source, I did set the 3 tablespaces READ ONLY.
I then exported them :
expdp bjohn/**** dumpfile=ora10.dmp directory=xttsdp logfile=exp.log transport_full_check=y transport_tablespaces=LABTENONE,LABTENTWO,LABTENTREE
And tried import:
impdp byabre/oracle1 directory=xttsdp logfile=tts_imp.log \
dumpfile=ora105.dmp \
transport_datafiles='/oradata/linuxtwe/LINUXTWE/datafile/LABTENONE_5.xtf','/oradata/linuxtwe/LINUXTWE/datafile/LABTENTWO_6.xtf','/oradata/linuxtwe/LINUXTWE/datafile/LABTENTREE_7.xtf'
I had the error message: datafile '/oradata/linuxtwe/LINUXTWE/datafile/LABTENTREE_7.xtf' is an incorrect version
I then add version=12 to the export command but it is saying version=12 is not supported.
My question: is it possible to do transportable tablespace from a 10.2.0.5 to a 12c database as the oracle documentation say?
Any suggestion will be appreciated.
Thanks.