Database Utilities (MOSC)

MOSC Banner

expdp does not export user jobs for MV refresh

edited Sep 21, 2013 3:51AM in Database Utilities (MOSC) 3 commentsAnswered
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).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center