|
|
|
|
| Re: different between move and shink table [message #521449 is a reply to message #517060] |
Tue, 30 August 2011 01:27  |
jai_subi
Messages: 7
Registered: May 2007
Location: Chennai
|
Junior Member |
|
|
Empty_blocks do not change after alter table move clause whereas empty_blocks decrease after shrink clause.
The below query helps you to verify:
select table_name,a.blocks,b.bytes/1024 as KB,num_rows,empty_blocks
from user_tables a, user_segments b
where a.table_name = b.segment_name
and empty_blocks >0 order by empty_blocks desc
Regards,
subi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
