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

TABLE: SYS.WRMS$_SNAPSHOT

Object Details
Object Name: WRMS$_SNAPSHOT
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Columns
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
Query Text

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;

Dependencies

[top of page]

SYS.WRMS$_SNAPSHOT does not reference any database object

SYS.WRMS$_SNAPSHOT is not referenced by any database object