SQL> create table T_28672_EMPNO compress

 2   as select * from T_28672 order by EMPNO;

Table created.

SQL> create table T_28672_COMM compress

 2   as select * from T_28672 order by COMM;

Table created.

SQL> execute show_space('T_28672');

Unformatted Blocks .....................              0

FS1 Blocks (0-25) ......................               0

FS2 Blocks (25-50) .....................              0

FS3 Blocks (50-75) .....................              0

FS4 Blocks (75-100).....................              0

Full Blocks ............................             43

Total Blocks............................             48

Total Bytes.............................        393,216

Total MBytes............................              0

Unused Blocks...........................              0

Unused Bytes............................              0

Last Used Ext FileId....................              4

Last Used Ext BlockId...................          3,897

Last Used Block.........................              8

PL/SQL procedure successfully completed.

SQL> execute show_space('T_28672_EMPNO);

ERROR:

ORA-01756: quoted string not properly terminated

SQL> execute show_space('T_28672_EMPNO');

Unformatted Blocks .....................              0

FS1 Blocks (0-25) ......................              0

FS2 Blocks (25-50) .....................              0

FS3 Blocks (50-75) .....................              0

FS4 Blocks (75-100).....................              0

Full Blocks ............................             40

Total Blocks............................             48

Total Bytes.............................        393,216

Total MBytes............................              0

Unused Blocks...........................              3

Unused Bytes............................         24,576

Last Used Ext FileId....................              4

Last Used Ext BlockId...................          3,769

Last Used Block.........................              5

PL/SQL procedure successfully completed.

SQL> execute show_space('T_28672_COMM');

Unformatted Blocks .....................              0

FS1 Blocks (0-25) ......................              0

FS2 Blocks (25-50) .....................              0

FS3 Blocks (50-75) .....................              0

FS4 Blocks (75-100).....................              0

Full Blocks ............................             41

Total Blocks............................             48

Total Bytes.............................        393,216

Total MBytes............................              0

Unused Blocks...........................              2

Unused Bytes............................         16,384

Last Used Ext FileId....................              4

Last Used Ext BlockId...................          3,817

Last Used Block.........................              6

PL/SQL procedure successfully completed.

SQL>