Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to tell which datafile a table is in.

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

From: Dr. Jan Dieckmann <JDieckmann_at_psi.de>
Date: Wed, 03 Mar 1999 15:55:43 +0100
Message-ID: <36DD4D6F.48287345@psi.de>


You can use the tabregister "tablespace" of the tool Hora 3. See http://www.keeptool.com for a free trial version of Hora 3.

regards Jan Dieckmann

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 Wed Mar 03 1999 - 08:55:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US