Quote Originally Posted by darshilm View Post
PAVB, I am not using drop storage option.

Unfortunately, I do not have access to DBA_EXTENTS view. But I could get the following stats from ALL_TABLES

Initial Extent = 65536
Next Extent = NULL
Min Extent = 1
Max Extent = 2147483645
Blocks Used = 314176
Empty Blocks = 8
get the values from all_extents then.