eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: SYS.SNAP$

Object Details

Object Name:	SNAP$
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_SNAP1	NORMAL	UNIQUE	SYSTEM	VNAME SOWNER INSTSITE
SYS_IL0000000156C00047$$	LOB	UNIQUE	SYSTEM
SYS_IL0000000156C00049$$	LOB	UNIQUE	SYSTEM
I_SNAP2	NORMAL	NONUNIQUE	SYSTEM	PARENT_VNAME PARENT_SOWNER INSTSITE

Columns

Name	Datatype	Length	Mandatory
SOWNER	VARCHAR2	(128)	Yes
VNAME	VARCHAR2	(128)	Yes
TNAME	VARCHAR2	(128)	Yes
MVIEW	VARCHAR2	(128)
MOWNER	VARCHAR2	(128)
MASTER	VARCHAR2	(128)
MLINK	VARCHAR2	(128)
CAN_USE_LOG	VARCHAR2	(1)
SNAPSHOT	DATE
SNAPID	NUMBER
SSCN	NUMBER
SNAPTIME	DATE
TSCN	NUMBER
ERROR#	NUMBER
AUTO_FAST	VARCHAR2	(1)
AUTO_FUN	VARCHAR2	(200)
AUTO_DATE	DATE
REFGROUP	NUMBER
USTRG	VARCHAR2	(128)
USLOG	VARCHAR2	(128)
STATUS	NUMBER
MASTER_VERSION	NUMBER
TABLES	NUMBER
FIELD1	NUMBER
FIELD2	VARCHAR2	(128)
FLAG	NUMBER
QUERY_TXT	LONG	(0)
LOBMASKVEC	RAW	(255)
MTIME	DATE		Yes
MAS_ROLL_SEG	VARCHAR2	(128)
RSCN	NUMBER
REFHNT	NUMBER
QUERY_LEN	NUMBER
INSTSITE	NUMBER
FLAVOR_ID	NUMBER
OBJFLAG	NUMBER
SNA_TYPE_OID	RAW	(16)
SNA_TYPE_HASHCODE	RAW	(17)
SNA_TYPE_OWNER	VARCHAR2	(128)
SNA_TYPE_NAME	VARCHAR2	(128)
MAS_TYPE_OID	RAW	(16)
MAS_TYPE_HASHCODE	RAW	(17)
MAS_TYPE_OWNER	VARCHAR2	(128)
MAS_TYPE_NAME	VARCHAR2	(128)
PARENT_SOWNER	VARCHAR2	(128)
PARENT_VNAME	VARCHAR2	(128)
REL_QUERY	CLOB	(4000)
FLAG2	NUMBER
ALIAS_TXT	CLOB	(4000)
SYN_COUNT	NUMBER
FLAG3	NUMBER
EVAL_EDITION	VARCHAR2	(128)

Query Text

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


SELECT SOWNER
,      VNAME
,      TNAME
,      MVIEW
,      MOWNER
,      MASTER
,      MLINK
,      CAN_USE_LOG
,      SNAPSHOT
,      SNAPID
,      SSCN
,      SNAPTIME
,      TSCN
,      ERROR#
,      AUTO_FAST
,      AUTO_FUN
,      AUTO_DATE
,      REFGROUP
,      USTRG
,      USLOG
,      STATUS
,      MASTER_VERSION
,      TABLES
,      FIELD1
,      FIELD2
,      FLAG
,      QUERY_TXT
,      LOBMASKVEC
,      MTIME
,      MAS_ROLL_SEG
,      RSCN
,      REFHNT
,      QUERY_LEN
,      INSTSITE
,      FLAVOR_ID
,      OBJFLAG
,      SNA_TYPE_OID
,      SNA_TYPE_HASHCODE
,      SNA_TYPE_OWNER
,      SNA_TYPE_NAME
,      MAS_TYPE_OID
,      MAS_TYPE_HASHCODE
,      MAS_TYPE_OWNER
,      MAS_TYPE_NAME
,      PARENT_SOWNER
,      PARENT_VNAME
,      REL_QUERY
,      FLAG2
,      ALIAS_TXT
,      SYN_COUNT
,      FLAG3
,      EVAL_EDITION
FROM SYS.SNAP$;

Dependencies

[top of page]

SYS.SNAP$ does not reference any database object

SYS.SNAP$ is referenced by following:

CTXSYS: DRIXMD - show dependent code
SYS: ACLMV$_MVINFO; ALL_MVIEW_ANALYSIS; ALL_SUMMARIES; DBA_MVIEWS; DBA_MVIEW_ANALYSIS; DBA_SNAPSHOTS; DBA_SUMMARIES; DBA_ZONEMAPS; DBA_ZONEMAP_MEASURES; DBMS_DEFERGEN - show dependent code; DBMS_DEFERGEN_INTERNAL - show dependent code; DBMS_EXTENDED_TTS_CHECKS - show dependent code; DBMS_FEATURE_PARTITION_SYSTEM - show dependent code; DBMS_FEATURE_PARTITION_USER - show dependent code; DBMS_IJOB - show dependent code; DBMS_IREFRESH - show dependent code; DBMS_ISNAPSHOT - show dependent code; DBMS_OFFLINE_SNAPSHOT_INTERNAL - show dependent code; DBMS_REPCAT_FLA - show dependent code; DBMS_REPCAT_FLA_UTL - show dependent code; DBMS_REPCAT_MIG_INTERNAL - show dependent code; DBMS_REPCAT_SNA_UTL - show dependent code; DBMS_REPCAT_UTL - show dependent code; DBMS_REPUTIL - show dependent code; DBMS_SNAPSHOT - show dependent code; DBMS_SNAPSHOT_UTL - show dependent code; DBMS_SNAP_INTERNAL - show dependent code; DBMS_STATS_INTERNAL - show dependent code; EXU11SNAP; EXU7DELSNAP; EXU7SNAP; EXU7SNAPU; EXU8DELSNAP; KU$_CLST_ZONEMAP_VIEW; KU$_MVPROP_VIEW; KU$_MZPROP_VIEW; KU$_M_VIEW_VIEW_BASE; KU$_TTS_MV_VIEW; REPCAT_REPOBJECT; STRADDLING_RS_OBJECTS; USER_MVIEW_ANALYSIS; USER_SUMMARIES; XS_DATA_SECURITY_UTIL - show dependent code