From 11.2.0.3 database to 12.2 using full transportable impdp
Hi
I have already created the 12.2 database and this also contains data(Few months back, I had applied datapump impdp and added some data to this database for testing and now planning to convert this to new LIVE)
The datafile locations(path) on 11.2.0.3 database and 12.2.0.1 database are different .Both servers are windows based -The tablespace names are the same,though
The plan is to copy the existing 11.2.0.3 database on old server to 12.2.0.1 existing database so I was thinking of doing full transportable expdp and impdp rather than datapump to get an exact same copy(data pump is having issues when the object already exists etc and throwing lots of errors etc)