Re: Table Space Errors..

From: Mike Moore <hicamel_at_mail.home.com>
Date: Sat, 31 Mar 2001 01:31:56 GMT
Message-ID: <gsax6.10144$ea6.1203679@news1.frmt1.sfba.home.com>

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 Fri Mar 30 2001 - 19:31:56 CST