Finally I am able to find the root cause for ORA-08103: object no
longer exists.
Root Cause Analyses:-
During executing of select statement if any other session has truncated the underling table used in select statement ,we got the error ORA-08103: object no longer exists.
Example :- Procedure PROC_1 ties to insert into table TABLE_1 which is refers table TABLE_2.
At the same time some other refresh has truncated the table TABLE_2.
Solution:- As a permanent solution, We should keep all the dimension as merge NOT Truncate/Insert.
Root Cause Analyses:-
During executing of select statement if any other session has truncated the underling table used in select statement ,we got the error ORA-08103: object no longer exists.
Example :- Procedure PROC_1 ties to insert into table TABLE_1 which is refers table TABLE_2.
At the same time some other refresh has truncated the table TABLE_2.
Solution:- As a permanent solution, We should keep all the dimension as merge NOT Truncate/Insert.
No comments:
Post a Comment