[Home] [Help] [Dependency Information]
Object Name: | V_$PROXY_DATAFILE |
---|---|
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) | ||
FILE# | NUMBER | |||
CREATION_CHANGE# | NUMBER | |||
CREATION_TIME | DATE | |||
RESETLOGS_CHANGE# | NUMBER | |||
RESETLOGS_TIME | DATE | |||
CHECKPOINT_CHANGE# | NUMBER | |||
CHECKPOINT_TIME | DATE | |||
ABSOLUTE_FUZZY_CHANGE# | NUMBER | |||
RECOVERY_FUZZY_CHANGE# | NUMBER | |||
RECOVERY_FUZZY_TIME | DATE | |||
INCREMENTAL_LEVEL | NUMBER | |||
ONLINE_FUZZY | VARCHAR2 | (3) | ||
BACKUP_FUZZY | VARCHAR2 | (3) | ||
BLOCKS | NUMBER | |||
BLOCK_SIZE | NUMBER | |||
OLDEST_OFFLINE_RANGE | NUMBER | |||
START_TIME | DATE | |||
COMPLETION_TIME | DATE | |||
ELAPSED_SECONDS | NUMBER | |||
CONTROLFILE_TYPE | VARCHAR2 | (1) | ||
KEEP | VARCHAR2 | (3) | ||
KEEP_UNTIL | DATE | |||
KEEP_OPTIONS | VARCHAR2 | (11) | ||
RMAN_STATUS_RECID | NUMBER | |||
RMAN_STATUS_STAMP | NUMBER | |||
FOREIGN_DBID | NUMBER | |||
PLUGGED_READONLY | VARCHAR2 | (3) | ||
PLUGIN_CHANGE# | NUMBER | |||
PLUGIN_RESETLOGS_CHANGE# | NUMBER | |||
PLUGIN_RESETLOGS_TIME | DATE | |||
CON_ID | NUMBER | |||
BACKED_BY_PDB | VARCHAR2 | (3) | ||
GUID | RAW | (16) |
Cut, paste (and edit) the following text to query this object:
SELECT RECID
, STAMP
, DEVICE_TYPE
, HANDLE
, COMMENTS
, MEDIA
, MEDIA_POOL
, TAG
, STATUS
, DELETED
, FILE#
, CREATION_CHANGE#
, CREATION_TIME
, RESETLOGS_CHANGE#
, RESETLOGS_TIME
, CHECKPOINT_CHANGE#
, CHECKPOINT_TIME
, ABSOLUTE_FUZZY_CHANGE#
, RECOVERY_FUZZY_CHANGE#
, RECOVERY_FUZZY_TIME
, INCREMENTAL_LEVEL
, ONLINE_FUZZY
, BACKUP_FUZZY
, BLOCKS
, BLOCK_SIZE
, OLDEST_OFFLINE_RANGE
, START_TIME
, COMPLETION_TIME
, ELAPSED_SECONDS
, CONTROLFILE_TYPE
, KEEP
, KEEP_UNTIL
, KEEP_OPTIONS
, RMAN_STATUS_RECID
, RMAN_STATUS_STAMP
, FOREIGN_DBID
, PLUGGED_READONLY
, PLUGIN_CHANGE#
, PLUGIN_RESETLOGS_CHANGE#
, PLUGIN_RESETLOGS_TIME
, CON_ID
, BACKED_BY_PDB
, GUID
FROM SYS.V_$PROXY_DATAFILE;
|
|
|