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

VIEW: SYS.EXU11SNAP

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes
OWNERID NUMBER
Yes
NAME VARCHAR2 (128) Yes
TABLE_NAME VARCHAR2 (128) Yes
MASTER_VIEW VARCHAR2 (128)
MASTER_LINK VARCHAR2 (128)
MTIME DATE
Yes
CAN_USE_LOG VARCHAR2 (3)
ERROR NUMBER

TYPE VARCHAR2 (8)
QUERY LONG (0)
FLAG NUMBER

ROWID_SNAP NUMBER

PRIMKEY_SNAP NUMBER

UPDATE_SNAP NUMBER

UPDATE_TRIG VARCHAR2 (128)
UPDATE_LOG VARCHAR2 (128)
MASTABS NUMBER

MASVER NUMBER

LOB_VECTOR VARCHAR2 (510)
SNAPSHOT DATE

SNAPID NUMBER

INSTSITE NUMBER

FLAVOR_ID NUMBER

RSCN NUMBER

OBJFLAG NUMBER

FLAG2 NUMBER

STATUS NUMBER

SNA_TYPE_OWNER VARCHAR2 (128)
SNA_TYPE_NAME VARCHAR2 (128)
PARENT_SOWNER VARCHAR2 (128)
PARENT_VNAME VARCHAR2 (128)
FILE_VER NUMBER

SQL_VER NUMBER

ALIAS_TXT CLOB (4000)
MVIEW_COMMENT VARCHAR2 (4000)
SYN_COUNT NUMBER

Query Text

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


SELECT OWNER
,      OWNERID
,      NAME
,      TABLE_NAME
,      MASTER_VIEW
,      MASTER_LINK
,      MTIME
,      CAN_USE_LOG
,      ERROR
,      TYPE
,      QUERY
,      FLAG
,      ROWID_SNAP
,      PRIMKEY_SNAP
,      UPDATE_SNAP
,      UPDATE_TRIG
,      UPDATE_LOG
,      MASTABS
,      MASVER
,      LOB_VECTOR
,      SNAPSHOT
,      SNAPID
,      INSTSITE
,      FLAVOR_ID
,      RSCN
,      OBJFLAG
,      FLAG2
,      STATUS
,      SNA_TYPE_OWNER
,      SNA_TYPE_NAME
,      PARENT_SOWNER
,      PARENT_VNAME
,      FILE_VER
,      SQL_VER
,      ALIAS_TXT
,      MVIEW_COMMENT
,      SYN_COUNT
FROM SYS.EXU11SNAP;

Dependencies

[top of page]

SYS.EXU11SNAP references the following:

SchemaSYS
TableCOM$
TableOBJ$
TableSNAP$
TableTAB$
TableUSER$
SYS.EXU11SNAP is referenced by following:

SchemaSYS
ViewEXU10SNAP
ViewEXU11SNAPI
ViewEXU11SNAPU
ViewEXU9SNAP