Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Which datafiles are my tables in?
Jurij Modic <jmodic_at_src.si> wrote in article
<35f4e58a.910941_at_news.siol.net>...
> On 8 Sep 1998 07:50:05 GMT, "Andy Hardy" <aph_at_glink.net.hk> wrote:
>
> >How do I find out which datafiles a particular table is in?
>
> You can use views DBA_EXTENTS and DBA_DATA_FILES to map each
> extent of a table to particular data file.
>
Jurij,
Thanks for that - works fine!
Andy Received on Tue Sep 08 1998 - 23:20:48 CDT