错误报告: 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: 文件大小 (12800000 块
ORA-01688表空间无法扩展
最新推荐文章于 2024-05-15 22:52:13 发布