Re: Backup mode information in data dictionary

moorthy_at_bham.mindspring.com (Moorthy N. Rekapalli) wrote:
>Hello There,
>
> Where in the data dictionary that I will find that the tablespace
>is in backup mode. I thought that the STATUS field of the
>DBA_TABLESPACES will show that information. I issued
>
>SQLDBA> ALTER TABLESPACE USER_DATA BEGIN BACKUP;
>
> After this, the status of the user_data tablespace is online. From
>this information, how can I tell that the tablespace is in backup
>mode.
>
> THANKS IN ADVANCE.
>
>Moorthy
>

SQL> select * from v$backup;

Naren Chintala
naren_at_mink.att.com Received on Thu Oct 03 1996 - 00:00:00 CEST