表空间已满,用下面这句查看一下表空间user_data的使用状况:
SELECT A.tablespace_name, A.FREE_M, B.TOTAL_M, B.TOTAL_M-A.FREE_M USED_M, A.FREE_M/B.TOTAL_M*100 FREE_PCT
FROM
(SELECT tablespace_name, sum(bytes)/1024/1024 FREE_M FROM dba_free_space GROUP BY tablespace_name) A,
(SELECT tablespace_name, sum(bytes)/1024/1024 TOTAL_M FROM dba_data_files GROUP BY tablespace_name) B
WHERE A.tablespace_name=B.tablespace_name
SELECT A.tablespace_name, A.FREE_M, B.TOTAL_M, B.TOTAL_M-A.FREE_M USED_M, A.FREE_M/B.TOTAL_M*100 FREE_PCT
FROM
(SELECT tablespace_name, sum(bytes)/1024/1024 FREE_M FROM dba_free_space GROUP BY tablespace_name) A,
(SELECT tablespace_name, sum(bytes)/1024/1024 TOTAL_M FROM dba_data_files GROUP BY tablespace_name) B
WHERE A.tablespace_name=B.tablespace_name
from dba_data_files
where tablespace_name='USER_DATA';
看看user_data中有哪些数据文件alter tablespace user_data
datafile '全路径文件名(从上面的结果中贴过来)'
autoextend on maxsize unlimited;