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