I am migrating DB which contains Two Databases in Oracle 11G(AIX) to 12C R2 in Windows. I am facing difficulty while full Transportable export, Because the EXPD command in AIX(Big Endien) doesn't support Transportable=always parameter.
I have decided to use approach where I will create tablespaces and users first in Target DB and then import the Schemas one by one using parfile.
I have done below steps:
1. Exported the DB from the 11G using below command
expdp system/password@VPMDB1 full=Y directory=xxxx logfile=xxxx
expdp system/password@VPMDB2 full=Y directory=xxxx logfile=xxxx
2. Created Container DB in 12C and added pluggable DB
3. Executing SQL file to create table spaces, users in to pluggable DB but Pluggable DB has max limit of datafiles. But source db contains datafiles which exceeds max limit.
Is it possible to increase max limit or do I need install Oracle patch?
For second approach I used existing exported dump,So please let me know If above expdp queries will work or not?
Is there any other fastest way to export db. I need export databases from around ~30 Sites
Many Thanks In Advance