Re: Table Space Errors..

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 31 Mar 2001 01:38:08 +0200
Message-ID: <tca634c1ijgm04@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 - 17:38:08 CST