ERROR: ORA-00604,ORA-01578,ORA-01110 [message #54363] |
Wed, 13 November 2002 10:10 |
Lisa
Messages: 31 Registered: September 2000
|
Member |
|
|
Help please,
i found this error
"ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 4416)
ORA-01110: data file 1: 'D:ORANTDATABASESYS1ORCL.ORA' ".,
can anyone what's going on..
|
|
|
|
Re: ERROR: ORA-00604,ORA-01578,ORA-01110 [message #54370 is a reply to message #54363] |
Wed, 13 November 2002 12:07 |
Trifon Anguelov
Messages: 514 Registered: June 2002
|
Senior Member |
|
|
Your SYSTEM tablespace (which hold the data dictionary) has a block corruption. You can try to find our which database objects has this corrupted block, and if you have Oracle 9i to do media block recovery. If it's an index you can drop and rebuid the index.
The most important question is why that happened - disk failure, application bug, or... Need to further investigate this.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
Re: ERROR: ORA-00604,ORA-01578,ORA-01110 [message #55300 is a reply to message #54363] |
Thu, 16 January 2003 08:18 |
sanjay kumar
Messages: 7 Registered: February 2002
|
Junior Member |
|
|
Hi,
This message is generally comes when you tried to drop a user which using TEMPORARY TABLESPACE as existed Permanent Tablespace of Databasee.g. SYSTEM.
So first drop the all objects of this User manually, then drop the user with:
DROP USER user_name CASCADE;
Then problem will resolved.
Thanks!
Sanjay
India.
|
|
|