Re: To Resize a Datafile to a Smaller Size

From: T. Schwickert <schwickert_at_yahoo.com>
Date: 1 Aug 2001 04:38:48 -0700
Message-ID: <5fcc15a8.0108010338.37aae663@posting.google.com>

Hi,

select 	owner||'.'||segment_name,
	tablespace_name,bytes

from dba_segments
where tablespace_name='tablespace_name'

Hth
 Thomas

Dino Hsu <dino1_nospam_at_ms1.hinet.net> wrote in message news:<c8afmt8l20ldsb2gu9np9a6lrrb9v04vmp_at_4ax.com>...
> On Wed, 01 Aug 2001 14:40:09 +0800, Dino Hsu
> <dino1_nospam_at_ms1.hinet.net> wrote:
>
> >Dear all,
> >
> >A related question is:
> >How to find the schema objects hosted by a tablespace?
> >
> >Dino
> >
>
> In addtion, how to view the sizes of these objects?
Received on Wed Aug 01 2001 - 06:38:48 CDT