HELP - Drop tablespace fails database file verification check.
Date: 1996/07/09
Message-ID: <4ruo8l$9qn_at_client2.news.psi.net>#1/1
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;
Thanx in advance for your help,
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
Don Flippo
Reply or email to flippo_at_laa.com Received on Tue Jul 09 1996 - 00:00:00 CEST