Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Disadvantage of Unlimited extent?
Hi,
we should not mix two things: one is unlimited extents for a table and the other is unlimited maxsize for a file. We can have a table with unlimited extents and still the maxsize can be limited. I think the main disadvantage of unlimited extents is performance degradation if the table grows and has not been reorganized for a long time.
Regards,
-- Pavel Polcar sooz_at_pobox.com wrote in message <360B1DAE.30E91E1D_at_pobox.com>...Received on Mon Sep 28 1998 - 00:00:00 CDT
>Unless you're doing some close monitoring at the OS level, you could
>fill a disk and then crash, potentially more damage. That's why
>filesystems are partitioned, too. If you're on NT ... I don't know what
>would happen.
>
>-sooz
>
>Ng TC wrote:
>>
>> Hi,
>>
>> Can anyone tell me what is the disadvantage of setting table extents to
>> unlimited?
>>
>> Thanks in advance.
>>
>> Regards,
>> Tse Chong
>>
>> Please reply to email:
>> tcng_at_yas.com.sg