A dumping ground for various Oracle DBA scripts, fixes, findings, and other stuff.
Tuesday, 16 June 2015
DBMS_REDEFINITION and Materialized View Logs
If you are redefining a table that has a materialized view log, then be careful to use the MView Log table name, rather than the MView Log name, for the registration
e.g.
-- Register MView Log: EXEC DBMS_REDEFINITION.REGISTER_DEPENDENT_OBJECT('SCOTT','SALES','SALES_INT',DBMS_REDEFINITION.CONS_MVLOG,'SCOTT','MLOG$_SALES','MLOG$_SALES_INT');
No comments:
Post a Comment