检查数据文件的位置如下: SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/marven/system01.dbf /u01/app/oracle/oradata/marven/undotbs1.dbf /u01/app/oracle/oradata/marven/sysaux01.dbf /u01/app/oracle/oradata/marven/users01.dbf /u01/app/oracle/oradata/marven/marven01.dbf 在操作系统上删除数据文件 SQL> !rm /u01/app/oracle/oradata/marven/*.dbf 创建表发生报错 SQL> create table test2 as select * from dba_tables; create table test2 as select * from dba_tables * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01116: error in opening database file 1 ORA-01110: data file 1: '/u01/app/oracle/oradata/marven/system01.dbf' ORA-27041: unable to open file Linux-x86_64 Error: 2: No such file or directory Additional information: 3