Xref: alice comp.databases.oracle.misc:27018 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.nacamar.de!black.news.nacamar.net!not-for-mail From: "Dr. Jan Dieckmann" Newsgroups: comp.databases.oracle.misc Subject: Re: How to tell which datafile a table is in. Date: Wed, 03 Mar 1999 15:55:43 +0100 Organization: PSI AG Lines: 20 Message-ID: <36DD4D6F.48287345@psi.de> References: <7b37bb$fdm$1@nnrp1.dejanews.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Mozilla 4.04 [en] (WinNT; I) To: tim.mcconechy@runtime.dk 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@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