Re: HELP - Drop tablespace fails database file verification check.

In <4ruo8l$9qn_at_client2.news.psi.net>, flippo_at_flink (Flippo) writes:
>Any suggestions on a safe solution to this problem
>will be appreciated:
>
>Tablespace xxxxx was created some time ago. In the process
>of testing a revised DDL script, the xxxxx.dbf file was deleted
>external to Oracle. Oracle would not drop the tablespace
>because the dbf file could not be found. The DDL script was
>invoked again, and a new dbf file got created, but its File_Id
>was different. Now the tablespace cannot be dropped because
>of the error message below. No data has to be preserved, just suggest
>what can be done to clean up the system tables and drop and
>rebuild the tablespace.
>
>Oracle7 Server Release 7.1.6.2.0 - Production Release
>
>SQL> drop tablespace xxxxx;
>drop tablespace xxxxx
>*
>ERROR at line 1:
>ORA-01122: database file 8 failed verification check
>ORA-01110: data file 8: '/NetPath/nfs/xxxxx.dbf'
>ORA-01204: file number is 16 rather than 8 - wrong file
>
>Thanx in advance for your help,
>Don Flippo
>
>Reply or email to flippo_at_laa.com

This procedure is normally used to start the DB if a datafile was accidently deleted and cannot be recovered. Use to OS to Delete xxxxx.dbf then in SQLDBA run the following commands:

1. startup mount
2. alter database datafile '/netpath/nfs/xxxxx.dbf' offline drop;
3. alter database open;
4. drop tablespace xxxxx;

M.Landa Received on Wed Jul 10 1996 - 00:00:00 CEST