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

From: Steve Phelan <stevep_at_toneline.n-o-s-p-a-m.demon.co.uk>
Date: Thu, 25 Feb 1999 23:02:28 +0000
Message-ID: <36D5D684.C122B6BE@toneline.n-o-s-p-a-m.demon.co.uk>

Yes and no. My advice is don't bother. If you are that concerned, create a tablespace with one datafile and create this table in it.

Steve Phelan

(Oracle 7 & 8 OCP)

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 - 17:02:28 CST