Re: ORA-01578

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 10 Jun 1999 09:01:53 -0700
Message-ID: <375FE171.DF3366DB@us.oracle.com>

Root

Is the database needed? If not, just shut it down and delete the files. Otherwise, call Support to work out how to get the data out of the database. In this case, you have a corrupted SYSTEM tablespace and Support will guide you through the determination of whether you've damaged the data dictionary.

HTH. Pete

root wrote:

> Hi,
> I created a database manually, but when I try to drop the tablespace
> I get:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01578: ORACLE data block corrupted (file # 1, block # 3883)
> ORA-01110: data file 1: '/u02/oradata/CC1/systemCC101.dbf'
> I get the same messages when I try to create a table in the tablespace.
> How can I drop a segment and re-create it?
> How do you un-create a database - where can I get information
> about how to do this? The DBA handbook doesn't cover this.

Regards

Pete

Received on Thu Jun 10 1999 - 11:01:53 CDT