标题: ORA-10635: Invalid segment or tablespace type ORACLE 报错 [打印本页] 作者: 刘泽宇 时间: 2024-6-30 17:27 标题: ORA-10635: Invalid segment or tablespace type ORACLE 报错 当我在对shrink操作进行测试时,出现报错:
SYS@orclpdb>alter table tab_test5 shrink space compact;
alter table tab_test5 shrink space compact
*
ERROR at line 1:
ORA-10635: Invalid segment or tablespace type
检查一下表空间使用的段管理:
SYS@orclpdb>select TABLESPACE_NAME,SEGMENT_SPACE_MANAGEMENT from dba_tablespaces;
TABLESPACE_NAME SEGMEN
------------------------------ ------
SYSTEM MANUAL
SYSAUX AUTO
TEMP MANUAL
USERS AUTO
TSP_TEST AUTO
UNDOTBS2 MANUAL