Database Administration (MOSC)

MOSC Banner

dbms_metadata.get_ddl materialized view

edited May 19, 2011 7:15PM in Database Administration (MOSC) 5 commentsAnswered
 SEVERE 56           80813    oracle.dbtools.db.DBUtil

ORA-31603: object "objectname" of type MATERIALIZED_VIEW not found in schema "schema name"

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105

ORA-06512: at "SYS.DBMS_METADATA", line 3912

ORA-06512: at "SYS.DBMS_METADATA", line 5678

ORA-06512: at line 1.

I am getting this error while

select dbms_metadata.get_ddl('MATERIALIZED_VIEW','obejct_name','schema') from dual;

, I have recently upgraded from 10.2.0.3 to 11gr2. I have missed to stop the materialized view refresh before upgrade. This i have done on test server.

Please let me know how i can resolve this issue.

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