Created one dbf file from my database using following command,
alter tablesapce PAULA_INDEX add datafile '/u02/oradata/hfd1/index/index17.dbf' size 2000M;
This dbf file is created in my server locally /u02/oradata/hfd1/index/ path. And I am also able to view this file in my oracle database.
Now I want to delete this file from my database. And accidentally it was already removed locally from
/u02/oradata/hfd1/index/ path. Now I am not able to drop the file from my database. Please suggest what I can do.
I have tried,
alter tablespace PAULA_INDEX drop datafile '/u02/oradata/hfd1/index/index17.dbf';
But it is not dropped.