Re: Hot backup status , how to ?

In article <4i3p1u$liu_at_goanna.cs.rmit.EDU.AU>, Trung Nguyen Business Fact (trung_at_yallara.cs.rmit.EDU.AU) says...
!>
!>Hi,
!>Is there an easy way to query whether a particular tablespace is in hot
!>backup mode ? and to get a list of all tablespaces in hot backup mode ?
!>
!>Thanks for your help.
!>Trung

V$BACKUP gives you the datafiles, with which you can look up the tablespace in dba_data_files:

select distinct ddf.tablespace_name
 from dba_data_files ddf, v$backup vb
 where vb.status = 'ACTIVE'
 and vb.file# = ddf.file_id;

Please let me know if I introduced any bugs or butterflies.

-- 
Kind reGards
     \ /   |
      X    |
     / \   s
     Gerard