expdp does not export user jobs for MV refresh
Hi All,
I have Oracle standard 10gR2 which is having some MVs defined under schema "SchemaA".
CASE:1 expdp/impdp under SYSTEM
I plan to move this to 11gR2 instance, initially I did expdp under SYSTEM account and did impdp with SCHEMAS=<SchemaA> and was failing with following errors:
ORA-39083: Object type REFRESH_GROUP failed to create with error:
ORA-23421: job number 454 is not a job in the job queue
BUT I DID SEE ERRORS FOR creating dbms_refresh jobs for ALL MVs.
CASE:2 expdp/impdp under SchemaA
As per the ML article suggestion, I now did expdp from the schema to be exported and did impdp into the 11gR2 instance under SchemaA (both instance have same schema name).
0