Unless you are in a very specific situaiton
David Pulliam, July 18, 2017 - 1:12 pm UTC
I can think of a specific situation I ran into a few years ago where import export was our preferred route (right or wrong). We had reached the point where we had decided that it was time to dump our SPARC 64bit Solaris based hardware and go over to a x86-64 Redhat Linux based VMWare platform as well as move form Oracle 10gR2 to 11gR2. Here we had to go through an endian conversion. Also our storage setup was very different at the time as well which made us lean towards the idea of re-creating the tablespaces and datafiles for the database by hand (as the datafiles would not be readable properly so we understood at the time). I realize the person here is talking about staying on like hardware and system configuration but sometimes the import export option does have its merits and usefulness. Just a thought here.
July 18, 2017 - 1:52 pm UTC
Good point, I've had to do similar in the past myself.
suggestion/experience
A reader, July 22, 2017 - 3:17 am UTC
In my previous experience migrate 11gr1 -> 11gr2 ->12c
the steps we took.
1. install binary in different host or same host different directory.
2. create new database on differnet directory.
3. expdp from old database.
4. impdp into new version database.
5. enable golden gate replication between old db to new db.
once it is in sync, the migration is completed.
scott