Re: Dynamic views for datafiles and tablespaces

From: Paul Drake <paled_at_home.com>
Date: Thu, 30 Aug 2001 06:15:54 GMT
Message-ID: <3B8DD9CF.586264AB@home.com>

Dino,

If you are recovering a database - you will be very glad that v$datafile is available.
dba_tablespaces and dba_data_files are not available in a MOUNT state.

Paul

Dino Hsu wrote:
>
> Dear all,
>
> When studying recovery, we most often talk about manipulations of
> datafiles and tablespaces. Although tablespace is a 'logical
> structure', it is still quite physical for me because one tablespace
> contains one or more datafiles, and 'datafile' is a 'physical
> structure'. Naturally I will compare their dynamic views:
>
Received on Thu Aug 30 2001 - 01:15:54 CDT