|
-
 Originally Posted by bjayaram
my question is, once a segment is in the free list, can i be allowed to delete data from that segment?
It would be nice if someone cud answer this question.
Not sure I understand this? Just because a block is on the freelist doesn't mean you can't delete from that block.
The block will remain on the freelist until it reaches the PCTFREE limit. Once it reaches the PCTFREE, the block will be taken off the freelist. If rows are deleted in the block or rows decrease in size due to updates and the freespace falls below PCTUSED, then the block is put back on the freelist.
Have you seen this How PCTFREE and PCTUSED Work Together.
If possible, use ASSM and you don't have to worry about this.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|