Solution : https://service.sap.com/sap/support/notes/1121838 (SAP Service marketplace login required)
Key words :
alter table <table_name> shrink space compacta running select statement, ziphp-ux pa-risc 64-bit /oracle/oracle 64-bit/oracle 10, ziphp-ux itanium 64-bit /oracle/oracle 64-bit/oracle 10, zipsun solaris 64-bit /oracle/oracle 64-bit/oracle 10, zipsun solaris x86-64 /oracle/oracle 64-bit/oracle 10, ziplinux ibmpower 64-bit /oracle/oracle 64-bit/oracle 10, ziphp tru64 /oracle/oracle 64-bit/oracle 10, ziplinux itanium 64 /oracle/oracle 64-bit/oracle 10, ziplinux 32-bit /oracle/oracle 32-bit/oracle 10, ziplinux x86-64 /oracle/oracle 64-bit/oracle 10
Related Notes :
| 910389 | FAQ: Oracle Segment Shrinking |
| 871096 | Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.2 |
| 619188 | FAQ: Oracle wait events |