Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

corrupt blocks in system tablespace

RoberJul 16 2010 — edited Jul 16 2010

Hi, I have an oracle database 10G R2 EE on suse linux enterprise server 10.

I have problems with a hard disk, and now I have several corrupt blocks. In total, I have 11 corrupt block in system tablespace and another corrupt block in other tablespace (ts_datos).

I want to recover ts_datos tablespace, but when I run an export utility (exp and expdp) it fails. Oracle show an error on system tablespace, and I can not export it.

I'm thinking create a new database and bring the ts_datos tablespace (datafiles) to my new database.

How can I do it?

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 13 2010

Added on Jul 16 2010

#general-database-discussions

8 comments

2,347 views