Mega Code Archive

 

Categories / Oracle PLSQL / Table

 

Show_space

SQL> SQL> SQL> SQL> SQL> create table t as select * from all_objects; Table created. SQL> SQL> create index t_idx on t(owner,object_type,object_name); Index created. SQL> SQL> exec show_space('T_IDX',user,'INDEX') Free Blocks 0 Total Blocks 80 Total Bytes 655360 Unused Blocks 7 Unused Bytes 57344 Last Used Ext FileId 1 Last Used Ext BlockId 42905 Last Used Block 1 PL/SQL procedure successfully completed. SQL> SQL> drop index t_idx; Index dropped. SQL> SQL> drop table t; Table dropped. SQL> --