Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |