问题描述:执行insert时报错ORA-00372、ORA-01110,如下所示: 数据库:oracle 11.2.0.4 1、异常重现 LEO@orcl150> insert into test$ select * from test$$; insert into test$ select * from test$$ * ERROR at line 1: ORA-00372: file 5 cannot be modified at this time ORA-01110: data file 5: ...
ORA-00372此时无法修改文件5 ORA-01110数据文件5'M:\DB_DATA\SEINESCMDB\WWFDATA_DATA01.dbf' 分析原因及解决方法: 1.查看表空间online状态 select t.online_status,t.file_name,t.tablespace_name from dba_data_files t where t.file_id in ('5'); 显示结果如下:属于正常 ONLINE M:\DB_DATA\SEINESCM...
32 35 ONLINE 4003.99219 /oracle10g/oradata/xzdata_4g_012 或者查询dba_data_files视图,online_status,file_id,tablespace_name SQL> select FILE_ID,FILE_NAME,TABLESPACE_NAME,BYTES/1024/1024 size_m,STATUS,ONLINE_STATUS from dba_data_files where file_id='35'; FILE_ID FILE_NAME TABLESPACE_NAME SI...
Database is crashed with ORA-00372. Below is the snippet from the alert log entries. Errors in file /<path>/..dbw4_38303.trc:ORA-00372: file 34 cannot be modified at this timeORA-01110: data file 34: '/<path>/...261.1006858737'Errors in file/<path>/.._dbw4_38303.trc (...
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later: TTS Import Fails with "ORA-00372: File Cannot Be Modified At This Time" when Charactersets Are Dif