[Home] [Help] [Dependency Information]
Object Name: | V_$DATAFILE_COPY |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECID | NUMBER | |||
STAMP | NUMBER | |||
NAME | VARCHAR2 | (513) | ||
TAG | VARCHAR2 | (32) | ||
FILE# | NUMBER | |||
RFILE# | NUMBER | |||
CREATION_CHANGE# | NUMBER | |||
CREATION_TIME | DATE | |||
RESETLOGS_CHANGE# | NUMBER | |||
RESETLOGS_TIME | DATE | |||
INCREMENTAL_LEVEL | NUMBER | |||
CHECKPOINT_CHANGE# | NUMBER | |||
CHECKPOINT_TIME | DATE | |||
ABSOLUTE_FUZZY_CHANGE# | NUMBER | |||
RECOVERY_FUZZY_CHANGE# | NUMBER | |||
RECOVERY_FUZZY_TIME | DATE | |||
ONLINE_FUZZY | VARCHAR2 | (3) | ||
BACKUP_FUZZY | VARCHAR2 | (3) | ||
MARKED_CORRUPT | NUMBER | |||
MEDIA_CORRUPT | NUMBER | |||
LOGICALLY_CORRUPT | NUMBER | |||
BLOCKS | NUMBER | |||
BLOCK_SIZE | NUMBER | |||
OLDEST_OFFLINE_RANGE | NUMBER | |||
DELETED | VARCHAR2 | (3) | ||
STATUS | VARCHAR2 | (1) | ||
COMPLETION_TIME | DATE | |||
CONTROLFILE_TYPE | VARCHAR2 | (1) | ||
KEEP | VARCHAR2 | (3) | ||
KEEP_UNTIL | DATE | |||
KEEP_OPTIONS | VARCHAR2 | (11) | ||
SCANNED | VARCHAR2 | (3) | ||
IS_RECOVERY_DEST_FILE | VARCHAR2 | (3) | ||
RMAN_STATUS_RECID | NUMBER | |||
RMAN_STATUS_STAMP | NUMBER | |||
CONVERTED_FILE | VARCHAR2 | (3) | ||
SAME_ENDIAN | VARCHAR2 | (3) | ||
FOREIGN_DBID | NUMBER | |||
PLUGGED_READONLY | VARCHAR2 | (3) | ||
PLUGIN_CHANGE# | NUMBER | |||
PLUGIN_RESETLOGS_CHANGE# | NUMBER | |||
PLUGIN_RESETLOGS_TIME | DATE | |||
BACKED_BY_VSS | VARCHAR2 | (3) | ||
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
, NAME
, TAG
, FILE#
, RFILE#
, CREATION_CHANGE#
, CREATION_TIME
, RESETLOGS_CHANGE#
, RESETLOGS_TIME
, INCREMENTAL_LEVEL
, CHECKPOINT_CHANGE#
, CHECKPOINT_TIME
, ABSOLUTE_FUZZY_CHANGE#
, RECOVERY_FUZZY_CHANGE#
, RECOVERY_FUZZY_TIME
, ONLINE_FUZZY
, BACKUP_FUZZY
, MARKED_CORRUPT
, MEDIA_CORRUPT
, LOGICALLY_CORRUPT
, BLOCKS
, BLOCK_SIZE
, OLDEST_OFFLINE_RANGE
, DELETED
, STATUS
, COMPLETION_TIME
, CONTROLFILE_TYPE
, KEEP
, KEEP_UNTIL
, KEEP_OPTIONS
, SCANNED
, IS_RECOVERY_DEST_FILE
, RMAN_STATUS_RECID
, RMAN_STATUS_STAMP
, CONVERTED_FILE
, SAME_ENDIAN
, FOREIGN_DBID
, PLUGGED_READONLY
, PLUGIN_CHANGE#
, PLUGIN_RESETLOGS_CHANGE#
, PLUGIN_RESETLOGS_TIME
, BACKED_BY_VSS
, CON_ID
, BACKED_BY_PDB
, GUID
FROM SYS.V_$DATAFILE_COPY;
|
|
|