Re: Which datafiles are table located?

From: Andrew Simkovsky <asimkovsky_at_msn.com>
Date: Tue, 8 May 2001 11:13:52 -0400
Message-ID: <#iqPGYD2AHA.139@cpmsnbbsa07>

Look in DBA_EXTENTS and DBA_SEGMENTS.

Andrew Simkovsky
OCP DBA
Pipeline Sysop
www.revealnet.com

ok wrote in message ...
>Hi, assume I have a ts with 30 datafiles, a big table was created in this
>ts, after many week's growing, is there a way to find out which datafiles
>this table used? Also what's the criteria Oracle to take space from
>different datafile?
>
>Thank you for sharing your knowledge.
>
>_________________
>OK
>
>--
>Posted via CNET Help.com
>http://www.help.com/
Received on Tue May 08 2001 - 10:13:52 CDT