[Home] [Help] [Dependency Information]
Object Name: | V_$PROXY_ARCHIVEDLOG |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECID | NUMBER | |||
STAMP | NUMBER | |||
DEVICE_TYPE | VARCHAR2 | (17) | ||
HANDLE | VARCHAR2 | (513) | ||
COMMENTS | VARCHAR2 | (81) | ||
MEDIA | VARCHAR2 | (65) | ||
MEDIA_POOL | NUMBER | |||
TAG | VARCHAR2 | (32) | ||
STATUS | VARCHAR2 | (1) | ||
DELETED | VARCHAR2 | (3) | ||
THREAD# | NUMBER | |||
SEQUENCE# | NUMBER | |||
RESETLOGS_CHANGE# | NUMBER | |||
RESETLOGS_TIME | DATE | |||
FIRST_CHANGE# | NUMBER | |||
FIRST_TIME | DATE | |||
NEXT_CHANGE# | NUMBER | |||
NEXT_TIME | DATE | |||
BLOCKS | NUMBER | |||
BLOCK_SIZE | NUMBER | |||
START_TIME | DATE | |||
COMPLETION_TIME | DATE | |||
ELAPSED_SECONDS | NUMBER | |||
RMAN_STATUS_RECID | NUMBER | |||
RMAN_STATUS_STAMP | NUMBER | |||
TERMINAL | VARCHAR2 | (3) | ||
KEEP | VARCHAR2 | (3) | ||
KEEP_UNTIL | DATE | |||
KEEP_OPTIONS | VARCHAR2 | (11) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT RECID
, STAMP
, DEVICE_TYPE
, HANDLE
, COMMENTS
, MEDIA
, MEDIA_POOL
, TAG
, STATUS
, DELETED
, THREAD#
, SEQUENCE#
, RESETLOGS_CHANGE#
, RESETLOGS_TIME
, FIRST_CHANGE#
, FIRST_TIME
, NEXT_CHANGE#
, NEXT_TIME
, BLOCKS
, BLOCK_SIZE
, START_TIME
, COMPLETION_TIME
, ELAPSED_SECONDS
, RMAN_STATUS_RECID
, RMAN_STATUS_STAMP
, TERMINAL
, KEEP
, KEEP_UNTIL
, KEEP_OPTIONS
, CON_ID
FROM SYS.V_$PROXY_ARCHIVEDLOG;
|
|
|