Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

From 11.2.0.3 database to 12.2 using full transportable impdp

edited Mar 8, 2019 11:10AM in Database Install/Upgrade/Opatch (MOSC) 7 commentsAnswered

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)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center