Database DataWarehousing (MOSC)

MOSC Banner

ORA-12096: error in materialized view log on "SYSADM"."ABC ORA-00942: table or view does not exist

edited Feb 3, 2010 1:56AM in Database DataWarehousing (MOSC) 3 commentsAnswered
 On 22nd Oct, a table MLOG$_ABC got created b'coz, I might have executed DBMS_REDEFINITION(SYSADM, ABC) and which we want to get rid off now.  
We want to get rid of MLOG$_ABC, When I DROP TABLE MLOG$_ABC; all the process (UPDATE or INSERT on table ABC) getting cancelled with the error below
 
ORA-12096: error in materialized view log on "SYSADM"."ABC ORA-00942: table or view does not exist

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