Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: objects contained in a datafile
Maybe I'm missing something but I don't think you addressed the question ... at least as I understand it. Let me rephrase it
as I read it and see if that helps.
Question:
Suppose a tablespace contains three datafiles. Suppose there are three tables created in the tablespace. And suppose that
each table, while in the same tablespace, is in a different datafile. Can you tell which table is in which datafile?
Daniel Morgan
Arthur Burdin wrote:
> 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 Mon Apr 22 2002 - 10:52:32 CDT