|
-
Hi,
I have not worked on TOAD, so I'll not comment on that.I suggest the following :-
1) Analyze the table with chained rows option.Prior to executing this command, the chained_rows table should be created.If my memory goes right, there is a scirpt called utlchain.sql which creates this chained_rows table.After the table is created, execute 'analyze table <tablename> list chained rows'.This will insert the rowid's of the chained rows into the chained rows table.Based on these rowid's, extract them into some temporary table, delete these rows from the original table and reinsert them back from the temporary table.
Second Alternative : Take an export of the table (No need to bring the database to a mount stage to do this.) Recreate the table with the revised pctfree setting.I don't think there is a hard and fast rule to find out the exact pctfree.You may need to make an approximate based on the expected update activity on the table.Reimport the data back.
Ramki
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
|