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

i think you'd have to use a command similar to select file_name

      from dba_datafile
    where tablespace_name = ( name of the table space your table is in )

i did this before a long time ago but i know this is what i did to find out hope this helps
daniel Kim

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 Fri Feb 26 1999 - 19:35:29 CST