Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: pros & cons of re-sizing vs adding new datafile
While we're *slightly* on this topic, what are the pros & cons of re-sizing
a datafile vs adding a new one to increase tablespace size? Are there
really any pros or cons, or just what seems appropriate for the situation?
Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message
news:37FDCE5A.49BC_at_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 Mon Oct 11 1999 - 06:40:19 CDT