RE: System tablespace corrupted
- From: Michael Fontana - at home <mfontana@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 28 Jul 2004 19:17:15 -0700 (PDT)
--- M Rafiq <rafiq9857@xxxxxxxxxxx> wrote:
> Waleed
> Thanks. Table name is
>
> SQL> select count(*) from
> sys.RESOURCE_CONSUMER_GROUP$;
> select count(*) from sys.RESOURCE_CONSUMER_GROUP$
> *
> ERROR at line 1:
> ORA-01578: ORACLE data block corrupted (file # 1,
> block # 223)
> ORA-01110: data file 1:
> 'F:\ORACLE\ORADATA\CBS\SYSTEM01.DBF'
If this is truly the only error you have, I think you
are in luck. This table could possibly be dropped and
copied from another environment without harm. If you
are not using database resource management (which, in
concept, allows for different cpu utilizations
depending on session requirements), you could simply
drop and recreate or copy from another, similar
database in your environment.
I am not using dbrm, and there are only four sample
rows in my table. I would first try copying from
another environment. If that doesn't work, the table
is created and loaded in the u0800050.sql conversion
scripts that should be in your
$ORACLE_HOME/rdbms/admin directory. Try that.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
