Re: objects contained in a datafile

Rsh, Renato,

There certainly is a "legitimate" way to see which objects belong to which tablespace and datafile(s). The main reason there MUST BE a legitimate way to see this info is for recovery.

Let's say I lost a cetain table. I have to be able to know from the data dictionary which tablespace/datafile(s) I should recover. If I wouldn't be able to find this info - then I would have to restore the whole database from the cold backup.

You can use the following data dictionary views to see the info you need:

1. v$dbfile, dba_data_files, dba_tablespaces to see which datafiles belong to which tablespace
2. dba_segments, dba_extents to map actual objects to tablespaces (and therefore, datafiles)
3. also, for recovery, you can use v$recover_file to see which datafiles should be recovered

Arthur Burdin
Sr.Oracle DBA

"RSH" <RSH_Oracle_at_worldnet.att.net> wrote in message news:<xWsw8.38115$Rw2.2883388_at_bgtnsc05-news.ops.worldnet.att.net>...
> Renato, datafiles are meant to be attached to and part of tablespaces, and
> tablespaces of course relate to the Oracle data dictionary in terms of
> defining what those bits of data mean; working together, the Oracle data
> dictionary, often stored in the SYSTEM tablespace, defines parametry like
> table names, columns, their characteristics and relationships with other
> objects, and so forth.
>
> There is no legitimate or proper way to directly examine a datafile that has
> been part of an Oracle database and make any sense out of it. If there is
> any improper way to do so, there shouldn't be.
>
> What is it you are trying to do?
>
> RSH.
>
>
> "Renato" <rsimonetto_at_replay.it> wrote in message
> news:a9or5m$p7c$1_at_fe1.cs.interbusiness.it...
> > how can i see the objects contained in a datafile and the space that they
> > use?
> > Thank you
> >
> >
Received on Sun Apr 21 2002 - 17:18:16 CDT