« Write to the alert log from PL/SQL code | Home | Oracle: find dependent objects »
List the tablespaces in backup mode
Small query to list Oracle tablespaces, that are in backup mode:
SELECT d.tablespace_name, b.time
FROM dba_data_files d, v$backup b
WHERE
d.file_id = b.FILE#
AND b.STATUS = 'ACTIVE' ;
FROM dba_data_files d, v$backup b
WHERE
d.file_id = b.FILE#
AND b.STATUS = 'ACTIVE' ;
Topics: Oracle, backup, tablespace | Submitter: checkthis
Comments
You must be logged in to post a comment.