Problém 42:
SQL> EXEC Dbms_Redefinition.Can_Redef_Table(‘TBS_ADM’, ‘TBLTEST’);BEGIN Dbms_Redefinition.Can_Redef_Table(‘TBS_ADM’, ‘TBLTEST’); END;*ERROR at line 1:ORA-12091: cannot online redefine table “TBS_ADM”.”TBLTEST” withmaterialized viewsORA-06512: at “SYS.DBMS_REDEFINITION”, line 137ORA-06512: at “SYS.DBMS_REDEFINITION”, line 1478ORA-06512: at line 1Elapsed: 00:00:00.01
Řešení:
SQL> select log_table from dba_snapshot_logs where log_table like ‘%TBLTEST%’;LOG_TABLE——————————MLOG$_TBLTESTElapsed: 00:00:00.02SQL> select master,log_table from dba_snapshot_logs where log_table like ‘%TBLTEST%’;MASTER LOG_TABLE—————————— ——————————TBLTEST MLOG$_TBLTESTElapsed: 00:00:00.02SQL> DROP MATERIALIZED VIEW LOG ON TBS_ADM.TBLTEST;Materialized view log dropped.Elapsed: 00:00:00.76SQL> EXEC Dbms_Redefinition.Can_Redef_Table(‘TBS_ADM’, ‘TBLTEST’);PL/SQL procedure successfully completed.Elapsed: 00:00:00.00
Metalink:
ORA-12091 Attempting Online Reorganization of Table with Materialized Views [ID 177408.1]