ORA-01157 how to get out of this situation - deleted DBF file
*
FEHLER in Zeile 1:
ORA-01157: Datendatei 12 kann nicht identifiziert/gesperrt werden - siehe
DBWR-Trace-Datei
ORA-01110: Datendatei 12:
'C:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL\E_DATA.DBF'
SQL>
Just before this I inadvertently deleted the datafile E_DATA.DBF
Somehow the database still is looking for this file. How can I repair this situation?
SQL> select name from v$datafile;NAME---------------------------------------------------------------------------C:\APP\CHRISLOCAL\ORADATA\ORCL\SYSTEM01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBSEED\SYSTEM01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\SYSAUX01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBSEED\SYSAUX01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\UNDOTBS01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\USERS01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL\SYSTEM01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL\SYSAUX01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL\SAMPLE_SCHEMA_USERS01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL\EXAMPLE01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL\E_DATA.DBFNAME-------------------------------------------------------------------C:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL01\SYSTEM01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL01\SYSAUX01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL01\PDBORCL01_USERS01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL01\E_DATA.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL2\SYSTEM01.DBFC:\APP\CHRISLOCAL\ORADATA\ORCL\PDBORCL2\SYSAUX01.DBF17 Zeilen ausgewõhlt.SQL>