Re: Table Space Errors..

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 - 02:41:52 CST