Re: Table and schema current size.

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Wed, 27 Jun 2001 14:04:01 +0100
Message-ID: <993647005.1751.0.nnrp-01.c30bdde2@news.demon.co.uk>

For the allocated size of each segment (well, you never specified... ;-))

select owner,segment_name,segment_type,bytes from dba_segments;

"Peter Shvets" <pshvets_at_powermarket.com> wrote in message news:9hamoe$1rlg$1_at_news.mainstreet.net...
> Hello, dear friends.
> I need to find out how big is every single table in the schema I have as
> well as the size of the schema itself.
> I am not a DBA, so I apologize for too simple question. :)
>
> Thanks in advance.
>
> Peter Shvets.
>
>
Received on Wed Jun 27 2001 - 08:04:01 CDT