Re: Dynamic views for datafiles and tablespaces

From: Dario Bilic <dario_bilic_at_yahoo.com>
Date: Wed, 29 Aug 2001 16:26:59 +0200
Message-ID: <9miu3k$a6q0$1@as201.hinet.hr>

Dino,

If the tablespace of a datafile is in backup mode, STATUS from V$DATAFILE will be ONLINE.

Dario

"Dino Hsu" <dino1.nospam_at_ms1.hinet.net> wrote in message news:qmupot8b8rrvm60j9r36ciq43j3b829dkn_at_4ax.com...
> On Wed, 29 Aug 2001 15:52:36 +0200, "Dario Bilic"
> <dario_bilic_at_yahoo.com> wrote:
>
> >Dino,
> >
> >V$DATAFILE is dynamic performance view which contains datafile
information
> >from the control file.
> >STATUS describes type of file (system or user) and its status.
> >Values: OFFLINE, ONLINE, SYSTEM, RECOVER, SYSOFF (an offline file from
the
> >SYSTEM tablespace)
> If the tablespace of a datafile is in backup mode, what will its
> status be?
>
> >
> >DBA_DATA_FILES is static data dictionary view which decribes data files.
> >STATUS can be either AVAILABLE or INVALID (INVALID means that
> >that the file number is not in use, e.g. a file in a tablespace that was
> >dropped)
> >
> >snip
> >
>
> Dino
>
Received on Wed Aug 29 2001 - 09:26:59 CDT