ORA-01653 表 PDM91.RAWSERVLETREQUESTSTATS 无法通过1024 （在表空间 USERS 中） 扩展

问题

解决办法

第一步：查询各表空间使用率

SELECT total.tablespace_name,
       Round(total.MB, 2)           AS Total_MB,
       Round(total.MB - free.MB, 2) AS Used_MB,
       Round(( 1 - free.MB / total.MB ) * 100, 2)
       || '%'                       AS Used_Pct
FROM   (SELECT tablespace_name,
               Sum(bytes) / 1024 / 1024 AS MB
        FROM   dba_free_space
        GROUP  BY tablespace_name) free,
       (SELECT tablespace_name,
               Sum(bytes) / 1024 / 1024 AS MB
        FROM   dba_data_files
        GROUP  BY tablespace_name) total
WHERE  free.tablespace_name = total.tablespace_name;

第二步：查询各表空间的实体文件位置

select tablespace_name, file_id, file_name,round(bytes/(1024*1024),0) total_space from dba_data_files order by tablespace_name

第三部：根据结果,增加表空间文件

以USERS表为例：

ALTER TABLESPACE users ADD DATAFILE 'D:\PTC\WINDCHILL_11.0\OCU\ORADATA\WIND\WINDUSERS02.DBF' size 3000M