Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to drop tablespace

to442951anApr 29 2005 — edited May 18 2005

Hi,

I accidentally delete a datafile of a newly created tablespace and then I want to do the tablespace. I am given the following error:

ERROR at line 1:
ORA-01122: database file 11 failed verification check
ORA-01110: data file 11: '/u01/oracle/OraHome/oradata/admsdev/ZZZ.dbf'
ORA-01251: Unknown File Header Version read for file number 11

How can I delete the tablespace without checking the existence of the datafile? My database server version is oracle 8.1.7.

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 15 2005

Added on Apr 29 2005

#general-database-discussions

3 comments

1,163 views