Re: freespace in tablespace

To reduce TEMP TS frag always make the init and next extents the same. For examples

Create Tablespace TEMP
...
Default Storage (Initial 4M Next 4M ...)

JHY wrote in message <6n9f34$dpg_at_bgtnsc01.worldnet.att.net>...
>If you run out of freespace when you know there is free space your free
>space might be fragmented. Happens a lot with temp tablespaces. Try
>ALTER TABLESPACE tablespace COALESCE.
>
>Ed Lufker wrote:
>
>> Hi All:
>>
>> What is a tablespaces problem when it is always running out of
>> free space????
>>
>> thanks in advance for any help
>> eddie lufker
>
>
>
Received on Wed Jul 01 1998 - 22:06:11 CDT