ORA-01654: 索引 ES.PK_ANY_SIGN_ELECTRON_INFO 无法通过 8 (在表空间 USERS 中) 扩展

索引表空间使用完了，或者磁盘满了 导致

查询剩余

select file_name,tablespace_name,bytes/1024/1024 from dba_data_files where tablespace_name='USERS'

新增

alter database datafile 'file_name' resize 1000M

alter database datafile 'F:\APP\ADMINISTRATOR\ORADATA\HTBASE\HTBASE02.DBF' resize 1000M

或者plsql 索引表空间改成正确的，我这边遇到的是使用的不正确的表空间，直接选择切换表空间就可以了

表空间查询
select 
a.tablespace_name,a.maxbytes/1024/1024 "Sum MB",a.bytes/1024/1024 "Present Sum MB",
(a.bytes-b.bytes)/1024/1024  "Used MB",
b.bytes/1024/1024 "Present Free MB",
(a.maxbytes-a.bytes+b.bytes)/1024/1024 "Free MB",
round(((a.bytes-b.bytes)/a.bytes)*100,2) "Present Percent_used",
round(((a.bytes-b.bytes)/a.maxbytes)*100,2) "Percent_used",
(case
 when (a.maxbytes-a.bytes+b.bytes)/1024/1024<=10240
 and (a.maxbytes-a.bytes+b.bytes)/a.bytes<=0.1
 then '警告！需添加数据文件! (╯°Д°)╯︵ ┻━┻'
 when  (a.maxbytes-a.bytes+b.bytes)/1024/1024<=30720
 and  (a.maxbytes-a.bytes+b.bytes)/1024/1024>10240
 and (a.maxbytes-a.bytes+b.bytes)/a.bytes<=0.3
 then '注意！表空间剩余容量偏小!╮(╯▽╰)╭'
 when (a.maxbytes-a.bytes+b.bytes)/1024/1024 is null
 then '数据文件出错了!(⊙o⊙)…'
 else '安全(*^__^*)'
 end) as warning
 from  (select tablespace_name,decode(sum(maxbytes),0,sum(bytes),sum(maxbytes)) maxbytes,sum(bytes) bytes from dba_data_files group by tablespace_name)  a
,(select tablespace_name,sum(bytes) bytes,
max(bytes) largest from dba_free_space group by tablespace_name) b 
where a.tablespace_name=b.tablespace_name  order by ((a.bytes-b.bytes)/a.bytes)  desc;