Re: Backup mode information in data dictionary

Moorthy N. Rekapalli wrote:
>
> Hello There,
>
> Where in the data dictionary that I will find that the tablespace
> is in backup mode.

You can use the v$backup view. Status for tablespace in backup mode is ACTIVE. To find file_name you can use the dba_data_files view. Try

    select t2.file_name, t1.status, t1.time from v$backup t1, dba_data_files t2       where t1.file# = t2.file_id and t1.status = 'ACTIVE';

Hope it helps.

-- 
Alik Shapiro
DBA, EDS, USA
The above statements and opinions are my own and do not
necessarily represent those of EDS.