/* ************************************************ */
/*                                                  */
/* Script: Backup status of all on-line datafiles   */                 *
/*                                                  */
/* name:    @c:\oracle\sql\v$backup.sql             */
/* date:    24-AUG-95                               */
/* creator: Rick Kupcunas                           */
/*                                                  */
/* ************************************************ */

set pagesize 65;
set linesize 80;


select substr(tablespace_name, 1, 15)    "TABLESPACE",
     file#, 
     a.status, 
     change#, 
     time
from v$backup a, 
     dba_data_files b
where a.file# = b.file_id;

commit;

