数据恢复的时候出现 ora-1157

Question

oracleora-01157

Answer 1

SQL> select sum(bytes)/1024/1024/1024 from v$datafile;SUM(BYTES)/1024/1024/1024
-------------------------
               0

Answer 2

SQL> select file#,name,bytes from v$datafile;                                                      FILE# NAME    BYTES
---------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------
 1 D:\ORACLE\PRODUCT\10.2.0\ORADATA\INTERLIB\SYSTEM01.DBF       0
 2 D:\ORACLE\PRODUCT\10.2.0\ORADATA\INTERLIB\UNDOTBS01.DBF       0
 3 D:\ORACLE\PRODUCT\10.2.0\ORADATA\INTERLIB\SYSAUX01.DBF       0
 4 D:\ORACLE\PRODUCT\10.2.0\ORADATA\INTERLIB\USERS01.DBF       0
 5 D:\ORACLE\PRODUCT\10.2.0\ORADATA\INTERLIB\INTERLIB.DBF       0