Database Administration (MOSC)

MOSC Banner

dba_tab_modifications

edited Apr 11, 2013 9:57AM in Database Administration (MOSC) 2 commentsAnswered
Hello

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

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