Re: Which datafiles are table located?

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Tue, 15 May 2001 02:37:39 GMT
Message-ID: <3B0097B8.A431B8E7@telusplanet.net>

If you look through the Oracle Admin manuals, you'll note that ROWID includes file information. It takes a bit of fiddling to extricate that information , then a bit more to link it to file.

ok wrote:

> 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 Mon May 14 2001 - 21:37:39 CDT