索引表空间使用完了,或者磁盘满了 导致
查询剩余
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