Check space with show_space for an index with compress 2 : Table space « Table « Oracle PL / SQL






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

Check space with show_space for an index with compress 2

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

Index created.

SQL>
SQL> exec show_space('T_IDX',user,'INDEX')
Free Blocks
0
Total Blocks
56
Total Bytes
458752
Unused Blocks
4
Unused Bytes
32768
Last Used Ext FileId
1
Last Used Ext BlockId
42753
Last Used Block
4

PL/SQL procedure successfully completed.

SQL>
SQL> drop index t_idx;

Index dropped.

SQL>
SQL> drop table t;

Table dropped.

SQL>
SQL> --








Related examples in the same category

1.Change user default table space and temporary table space
2.Get default table space for current user
3.Moving Tables To New Tablespaces or Storage
4.heap table
5.Show_space
6.Check space with show_space for an index with compress 1
7.Create two indexes on one table and check the space
8.alter tablespace
9.Map user objects to tablespaces.
10.Measure the fragmentation of free space in all of the tablespaces in a database
11.The plsql user is created using the USERS and TEMP tablespace.