Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tablesizes
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
--
"Some days you're the pigeon, and some days you're the statue." Received on Fri Oct 08 1999 - 05:58:34 CDT