-
Error in Materialized Views REFRESH
DB: 10.2.0.1
When i try to Refresh the Mview as the schema owner, i get the following error ...
any ideas ?//
thanks a lot
Ron
==================================================
SQL> execute DBMS_MVIEW.REFRESH('dss.center_3x_mv');
execute DBMS_MVIEW.REFRESH('dss.center_3x_mv')
*
ORA-12008: error in materialized view refresh path
ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2430
ORA-06512: at line 1
SQL>
============================================
-
have you looked up that error code on metalink?
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|