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' ;
MemoSoup
Mix of the things I always forget
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' ;