Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Error: ORA-12008: error in materialized view refresh path

user12209274Nov 23 2010 — edited Nov 23 2010
Hello Dba' s

We are on 12.0.6 EBS with 10.2.0.5 DB on Sun solaris SPARC 64 bit.

We are getting below error while Refreshing Materialized View.

---------------------------------------------------------------------------
Start of log messages from FND_FILE
---------------------------------------------------------------------------
Error: ORA-12008: error in materialized view refresh path
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], [] Occured while Refreshing Materialized View
---------------------------------------------------------------------------
End of log messages from FND_FILE
---------------------------------------------------------------------------

Not sure how to proceed.We have just upgraded our database from 10.2.0.3 to 10.2.0.5.

Also we still have our test instance with 10.2.0.3 database ,there refreshing MV completed successfully.

Also refreshing through TOAD gives below error:-
BEGIN
DBMS_SNAPSHOT.REFRESH(
LIST => 'XXPPL.XXPPL_OPM_TRANSACTIONS_MV'
,PUSH_DEFERRED_RPC => TRUE
,REFRESH_AFTER_ERRORS => FALSE
,PURGE_OPTION => 1
,PARALLELISM => 0
,ATOMIC_REFRESH => TRUE
,NESTED => FALSE);
END;
/

Error at line 2
ORA-12008: error in materialized view refresh path
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2256
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2462
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2431
ORA-06512: at line 2



Please advice.

Thanks,

Edited by: user12209274 on Nov 23, 2010 2:10 AM

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 21 2010
Added on Nov 23 2010
#general-database-discussions
0 comments
500 views