10g to 11g Schema Refresh
Posted on 2012-03-20
Here is my scenario ..
I have a 10g (10.2.0.4) Database - Database A and i have cloned the same Database and upgraded it to 11g R2 (22.214.171.124) Database - Database B.
DATABASE A and DATABASE B has same Schema structure also.
I need to refresh Database B Schemas from Database A schemas.
The following are my questions :
1.) Will this be compatible, since i am doing an export/import of schemas from 10g to 11g.
2.) Should i need to do additional operations like validations.
3.) Is there any other way to do this other than export/import or Materialized Views.