Mega Code Archive

 

Categories / Oracle PLSQL / Table

 

Check space with show_space for an index with compress 1

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 1; Index created. SQL> SQL> exec show_space('T_IDX',user,'INDEX') Free Blocks 0 Total Blocks 64 Total Bytes 524288 Unused Blocks 0 Unused Bytes 0 Last Used Ext FileId 1 Last Used Ext BlockId 42889 Last Used Block 8 PL/SQL procedure successfully completed. SQL> SQL> SQL> drop index t_idx; Index dropped. SQL> SQL> drop table t; Table dropped. SQL> SQL> --