use free space in tablespace
hello,
please i need your help about how use free space in tablespace,
why i have this map tablespace
block_id size_in_blocks segments
394,834 8,975 DBXCOL.INV_PICKING_I4
403,809 1,795 DBXCOL.INV_PICKING_I4
405,604 6,160 DBXCOL.INV_PICKING_I5
411,764 1,540 DBXCOL.INV_PICKING_I5
413,304 6,160 "free"
419,464 5,125 DBXCOL.INV_PICKING_PK
424,589 1,025 DBXCOL.INV_PICKING_PK
425,614 3,590 DBXCOL.PRUEBA_PICKING
429,204 515 DBXCOL.PRUEBA_PICKING
in this map , i have 48M free , but i can`t create a object in this space ,
disclaimer
I coalesce tablespace , and pctincrese is 50 in tablespace storage
How i can create objects in this free space?
thanks for your information
Re: use free space in tablespace
Quote:
Originally posted by cazpa
... pctincrese is 50 in tablespace storage...
That's your problem right there -- keep it at 0 to avoid fragmentation, and preferably use LMT's.
Moving along ... you'll just have to mnake sure that each extent that you specify has a block available, unless you want to defragment by moving all your tables and indexes to new TS's.