Re: Table Space Errors..

You should also consider a NEXT clause. Otherwise the file increments in ridiculously small bits and pieces.

Hence,

'alter database datafile '/bing/bong/blah.dbf' autoextend on next 10M maxsize 500M'

Regards
HJR "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:3ac5a5c5$0$12249$cc9e4d1f_at_news.dial.pipex.com...
> append the MAXSIZE parameter
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Joe Blow" <zuestra_at_hotmail.com> wrote in message
> news:l16bct4bieif4tc8ajef5pg3aakt92nqhk_at_4ax.com...
> > How?
> >
> >
> > On Sat, 31 Mar 2001 01:31:56 GMT, "Mike Moore" <hicamel_at_mail.home.com>
 wrote:
> >
> > >I believe that you can set a limit on autoextend.
> > >Mike
> > >
> > >Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
> > >news:tca634c1ijgm04_at_beta-news.demon.nl...
> > >>
> > >> "Pestilence" <adonis__at_hotmail.com> wrote in message
> > >> news:kQ7x6.181681$t67.2923958_at_news1.rdc1.il.home.com...
> > >> > I just wanted to know if there is a way to have the table spaces
 manage
> > >> > themselves. There is a lot of data importing going on and I am
 always
> > >> > increasing table space. I was just wondering if there is something
 that
 can
> > >> > help me out.
> > >> >
> > >> >
> > >>
> > >> There is of course autoextend on tablespaces.
> > >> However this idea should be placed in the same category as
 pctincrease:
 you
> > >> usually create more disasters by introducing it than by avoiding to
 use
 it.
> > >> If you set the tablespaces to autoextend eventually they fill up this
 disk.
> > >> The result of that will be a lot of importing going on.
> > >>
> > >> Regards,
> > >>
> > >> Sybrand Bakker, Oracle DBA
> > >>
> > >>
> > >>
> > >
> >
>
>
Received on Sat Mar 31 2001 - 17:15:53 CST