Re: Help locating some information

From: <fitzjarrell_at_cox.net>
Date: Thu, 04 Oct 2007 07:47:16 -0700
Message-ID: <1191509236.744458.49610@50g2000hsm.googlegroups.com>

On Oct 4, 9:38 am, mister...._at_gmail.com wrote:
> Hi, I'm trying to determine the amount of space reserved for each
> datafile and the type of object it's storing. I've tried the
> DBA_TABLESPACES, DBA_DATA_FILES tables and I think I found the amount
> of space under the column MAXBYTES on the first table but I can't find
> any information regarding the object type. Any help would be welcomed.
>
> Thanks

You need to look further, into DBA_SEGMENTS or DBA_EXTENTS, to see what object types are contained in a given tablespace.

David Fitzjarrell Received on Thu Oct 04 2007 - 09:47:16 CDT