SQL> Alter Table tb_hxl_user Shrink Space Cascade;
Alter Table tb_hxl_user Shrink Space Cascade
*
ERROR at line 1:
ORA-10635: Invalid segment or tablespace type


SQL> desc tb_hxl_user;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 STATEDATE                                 NOT NULL DATE
 USERNUMBER                                NOT NULL VARCHAR2(13)
 PROVCODE                                  NOT NULL NUMBER
 REM1                                               VARCHAR2(100)
 REM2                                      NOT NULL VARCHAR2(100)
 REM3                                               VARCHAR2(100)
 REM4                                               VARCHAR2(100)
 REM5                                               VARCHAR2(100)
 REM6                                               VARCHAR2(100)
 REM7                                               VARCHAR2(100)
 REM8                                               VARCHAR2(100)
 REM9                                               VARCHAR2(100)
 REM10                                              VARCHAR2(100)
 CREATE_DATE                               NOT NULL DATE
 CREATE_BY                                 NOT NULL NUMBER
 LAST_UPDATE_DATE                          NOT NULL DATE
 LAST_UPDATE_BY                            NOT NULL NUMBER
 REM11                                              VARCHAR2(1024)
 REM12                                              CLOB

SQL> Select * From v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
PL/SQL Release 11.1.0.7.0 - Production
CORE    11.1.0.7.0      Production
TNS for 32-bit Windows: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

SQL> show user;
USER is "HXL"
SQL>
SQL> Select bb.default_tablespace,bb.username From dba_users bb
  2  Where bb.username ='HXL'
  3  /

DEFAULT_TABLESPACE             USERNAME
------------------------------ ------------------------------
TSP_HXL_01                     HXL

SQL> Select aa.TABLESPACE_NAME,aa.SEGMENT_SPACE_MANAGEMENT
  2  From  Dba_Tablespaces aa
  3  Where aa.TABLESPACE_NAME ='TSP_HXL_01';

TABLESPACE_NAME                SEGMEN
------------------------------ ------
TSP_HXL_01                     AUTO

SQL> Select aa.TABLE_NAME,aa.TABLESPACE_NAME
  2   From User_Tables aa Where aa.TABLE_NAME='TB_HXL_USER';

TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
TB_HXL_USER                    TSP_HXL_01

SQL>