Re: How to tell which datafile a table is in.

From: Torsten Borchert <T.Borchert_at_DeutschePost.de>
Date: Thu, 25 Feb 1999 12:45:47 +0100
Message-ID: <36D537EB.607199CA@DeutschePost.de>

Hi,

join DBA_EXTENTS and DBA_DATA_FILES ...

Torsten

tim.mcconechy_at_runtime.dk wrote:
>
> How can I tell which datafile a table is created into...
>
> Can i control this.
> I hvae windows NT
> but would like to know the answer for UNIX too.
>
> I thought it was v$sqlare but can't seem to extract the datafile name...
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Feb 25 1999 - 05:45:47 CST