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