oracle 表空间无法扩展,ORA-01688表空间无法扩展

错误报告:

SQL 错误: ORA-01688: 表 JINRILOG.USEROPERATELOG 分区 P1 无法通过 8192 (在表空间 JINRILOG 中) 扩展

01688. 00000 - "unable to extend table %s.%s partition %s by %s in tablespace %s"

*Cause: Failed to allocate an extent for table segment in tablespace.

*Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more

files to the tablespace indicated.

-----解决过程：

第一步：确认是否自动扩展打开

SELECT file_id, file_name, tablespace_name, autoextensible, increment_by

FROM dba_data_files

WHERE tablespace_name = 'JINRILOG'

order by file_id desc;

第二步：尝试resize文件大小

SQL> alter database datafile 'S:\APP\ADMINISTRATOR\ORADATA\ORCL\JINRILOG01.DBF' resize 100000M;

alter database datafile 'S:\APP\ADMINISTRATOR\ORADATA\ORCL\JINRILOG01.DBF' resize 100000M

*

第 1 行出现错误:

ORA-01144: 文