DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_TAB_MODIFICATIONS

Object Details
Object Name: CDB_TAB_MODIFICATIONS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Information regarding modifications to tables in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
TABLE_OWNER VARCHAR2 (30)
Owner of modified table
TABLE_NAME VARCHAR2 (30)
Modified table
PARTITION_NAME VARCHAR2 (30)
Modified partition
SUBPARTITION_NAME VARCHAR2 (30)
Modified subpartition
INSERTS NUMBER

Approximate number of rows inserted since last analyze
UPDATES NUMBER

Approximate number of rows updated since last analyze
DELETES NUMBER

Approximate number of rows deleted since last analyze
TIMESTAMP DATE

Timestamp of last time this row was modified
TRUNCATED VARCHAR2 (3)
Was this object truncated since the last analyze?
DROP_SEGMENTS NUMBER

Number of (sub)partition segment dropped since the last analyze?
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TABLE_OWNER
,      TABLE_NAME
,      PARTITION_NAME
,      SUBPARTITION_NAME
,      INSERTS
,      UPDATES
,      DELETES
,      TIMESTAMP
,      TRUNCATED
,      DROP_SEGMENTS
,      CON_ID
FROM SYS.CDB_TAB_MODIFICATIONS;

Dependencies

[top of page]

SYS.CDB_TAB_MODIFICATIONS does not reference any database object

SYS.CDB_TAB_MODIFICATIONS is referenced by following:

SchemaPUBLIC
SynonymCDB_TAB_MODIFICATIONS