Hello,
From the source database platform (11gR2, win2008) , i executed:
expdp mis_user/password@mis schemas=mis_user directory=TEST_DIR dumpfile=mis_N2.dmp logfile=expdpmis_N2.log
After that, i moved <mis_N2.dmp> to target platform (12cR1, win2012R2), i executed:
impdp mis_user/password@mis schemas=mis_user directory=TEST_DIR dumpfile=mis_N2.dmp logfile=impdpmis_N2.log TABLE_EXISTS_ACTION=REPLACE INCLUDE=TABLE,INDEX
There is no errors while there is importing, but
1. May i know why all Stored Procedures / Views inside 12cR2 are required to be recompile? and
2. Are there any drawsback / missing action behind this?
Thank you very much.