VIEW: SYS.V_$DATAFILE_COPY

Source

View Text - Preformatted

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 v$datafile_copy

View Text - HTML Formatted

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 V$DATAFILE_COPY