Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tablesizes

Re: Tablesizes

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 08 Oct 1999 18:58:34 +0800
Message-ID: <37FDCE5A.49BC@yahoo.com>


Evert J. Smit wrote:
>
> Which sql-statement can I use to see the sizes of the tables of a
> specific user ?
>
> Is it possible to alter a tablespacee with a mximum size without
> adding a new datafile ?
>
> Thanks,
> Evert

select * from dba_segments
where owner = 'BLAH'

select owner, sum(bytes)
from dba_segments
group by owner;

alter database datafile 'blah blah' resize 1000m;

HTH
--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Oct 08 1999 - 05:58:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US