[Home] [Help] [Dependency Information]
Object Name: | SNAP$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
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 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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$;
SYS.SNAP$ does not reference any database object
SYS.SNAP$ is referenced by following:
|
|
|