Database Administration (MOSC)

MOSC Banner

Accidentally deleted datafiles from OS level ORA-01116 error in opening database file

edited Sep 12, 2011 3:54AM in Database Administration (MOSC) 5 commentsAnswered
Hallo!We were trying to delete a tablespace from the database.Unfortunately,we went to the OS level and deleted datafile TBS_DOCPROC_DEV.dbf from the server (equivalent to doing rm /oracle/apps/oradata/FCAT/TBS_DOCPROC_DEV.dbf).Now when we try to delete its associated tablespace that had only that one datafile,I am getting the error

ORA-01116: error in opening database file 14 ORA-01110: data file 14: '/oracle/apps/oradata/FCAT/TBS_DOCPROC_DEV.dbf' ORA-27041: unable to open file HPUX-ia64 Error: 2: No such file or directory Additional information: 3

How do I resolve this and delete the tablespace from database level?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center