Mega Code Archive

 

Categories / Oracle PLSQL / Table

 

Check space with show_space for an index with compress 2

SQL> SQL> create table t as select * from all_objects; Table created. SQL> SQL> create index t_idx on   2  t(owner,object_type,object_name)   3  compress 2; Index created. SQL> SQL> exec show_space('T_IDX',user,'INDEX') Free Blocks 0 Total Blocks 56 Total Bytes 458752 Unused Blocks 4 Unused Bytes 32768 Last Used Ext FileId 1 Last Used Ext BlockId 42753 Last Used Block 4 PL/SQL procedure successfully completed. SQL> SQL> drop index t_idx; Index dropped. SQL> SQL> drop table t; Table dropped. SQL> SQL> --