Re: Dynamic views for datafiles and tablespaces

From: Dino Hsu <dino1.nospam_at_ms1.hinet.net>
Date: Wed, 29 Aug 2001 22:24:47 +0800
Message-ID: <qmupot8b8rrvm60j9r36ciq43j3b829dkn@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:24:47 CDT