Hi there, I was trying to add a 2020 Mb dbf in tablespace. however the file system space didn't allow me to create it. I was tryng many times an deletig the dbf in UNIX because it woulnd't allow to create it in the tablespace.
Suddenly it allowed to create it and unfortunately I had removed the file
now I can't start my instance database
I get
ORA-01157: cannot identify/lock data file 242 - see DBWR trace file
ORA-01110: data file 242: '/d03/sifra/ireg08_03.dbf'

I had heard I could modify a config file so the reference didn't poin that file removed file anymore but I don't know which one.
can you help ?