recovery from ORA-01200 error

From: Braxton Robbason <robbason_at_hotmail.com>
Date: Wed, 14 Mar 2001 18:07:37 -0500
Message-ID: <tavu4ccfu7fc7c@corp.supernews.com>

hi all. I have a development db server that I crashed in a most horrible way. I had a program writing data into the USERS tablespace, which was stored in one big file that got to be too large for the disk to hold.

now, when I try to start the database I get:

ORA-01122: database file 5 failed verification check
ORA-01110: data file 5: '/data/oradata/ORCL/users01.dbf'
ORA-01200: actual file size of 2027014 is smaller than correct size of

2097138 blocks

I know I am supposed to restore from a backup at this point. I don't have a backup because this is just a development server. do I have to delete this database and make a new one or is there a way to maybe even lose the whole tablespace but recover the database itself? I feel like there should be a way to hack it.

Sheepishly,

Braxton Received on Wed Mar 14 2001 - 17:07:37 CST