Shulou(Shulou.com)06/01 Report--

Set up a test table

Create table T_table nologging as select * from dba_objects;create table t_table_1 nologging as select * from dba_tables

-- establish logging

Create materialized view log on T_table with rowid,sequence (object_name,object_type,owner) including new values;create materialized view log on t_table_1 with rowid,sequence (table_name) including new values

-- establish a materialized view

Create materialized view mv_t_table nologging refresh fast on demand with rowid START WITH TO_DATE ('21-08-2017 10 NEXT SYSDATE 09 NEXT SYSDATE 08, 'DD-MM-YYYY HH24:MI:SS') NEXT SYSDATE + 1 / (24060) as select count (*), a.objectseal type where a.object_name=b.table_name group by a.owner from T_table a where a.object_name=b.table_name group by a where a.object_name=b.table_name group by a.owner

-- testing

Select * from mv_t_table where owner='SYSTEM';delete from t_table where owner='SYSTEM';insert into t_table select * from dba_objects where owner='SYSTEM'

-- View the number of logs generated

Select a.name, b.value from v$statname a, v$mystat b where a.statistic# = b.statistic# and a.name = 'redo size'

-- View the refresh log

SELECT owner,mview_name,last_refresh_scn,last_refresh_date,query,REVISION FROM dba_mview_analysis WHERE owner='UTF32'

-- check the logging table. MLOG$ is a logging table. Once the update is completed, the contents of this table will be deleted.

Select * from MLOG$_T_TABLEselect * from MLOG$_T_TABLE_1

For official instructions, please see: http://docs.oracle.com/cd/E11882_01/server.112/e10706/repmview.htm#REPLN265

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.