[Home] [Help] [Dependency Information]
Object Name: | WRMS$_SNAPSHOT |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SNAP_ID | NUMBER | Yes | ||
DBID | NUMBER | Yes | ||
INSTANCE_NUMBER | NUMBER | Yes | ||
STARTUP_TIME | TIMESTAMP(3) | (11) | Yes | |
BEGIN_INTERVAL_TIME | TIMESTAMP(3) | (11) | Yes | |
END_INTERVAL_TIME | TIMESTAMP(3) | (11) | Yes | |
FLUSH_ELAPSED | INTERVAL DAY(5) TO SECOND(1) | (11) | ||
SNAP_LEVEL | NUMBER | |||
STATUS | NUMBER | |||
ERROR_COUNT | NUMBER | |||
BL_MOVED | NUMBER | |||
SNAP_FLAG | NUMBER | |||
SNAP_TIMEZONE | INTERVAL DAY(0) TO SECOND(0) | (11) | ||
STAGE_INST_ID | NUMBER | Yes | ||
STAGE_ID | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT SNAP_ID
, DBID
, INSTANCE_NUMBER
, STARTUP_TIME
, BEGIN_INTERVAL_TIME
, END_INTERVAL_TIME
, FLUSH_ELAPSED
, SNAP_LEVEL
, STATUS
, ERROR_COUNT
, BL_MOVED
, SNAP_FLAG
, SNAP_TIMEZONE
, STAGE_INST_ID
, STAGE_ID
FROM SYS.WRMS$_SNAPSHOT;
SYS.WRMS$_SNAPSHOT does not reference any database object
SYS.WRMS$_SNAPSHOT is not referenced by any database object
|
|
|