Show_space : Table space « Table « Oracle PL / SQL

1. Oracle PL / SQL
2. Table
3. Table space

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> --

   
  

Related examples in the same category