dba_tab_modifications
ORACLE 11Gr2 on Solaris 10 RAC with ASM.
I got sometheing strange on this view sys.dba_tab_modifications :
SQL> select count(1) from sys.dba_tab_modifications;
COUNT(1)
----------
618
SQL> select * from sys.dba_tab_modifications;
no rows selected
why?
SQL> select * from dba_tab_modifications where TABLE_OWNER='MG';
TABLE_OWNER TABLE_NAME PARTITION_NAME SUBPARTITION_NAME INSERTS UPDATES DELETES TIMESTAMP TRU DROP_SEGMENTS
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------- ---------- ---------- --------- --- -------------
MG TEST 100 0 0 11-APR-13 NO 0
MG TT 625 0 0 11-APR-13 NO 0
any ideas ?
DDL
CREATE OR REPLACE FORCE VIEW "SYS"."DBA_TAB_MODIFICATIONS" ("TABLE_OWNER", "TABLE_NAME", "PARTITION_NAME", "SUBPARTITION_NAME", "INSERTS", "UPDATES", "DELETES