Home » RDBMS Server » Server Administration » Data Block Corrupted in Rollback Segment
Data Block Corrupted in Rollback Segment [message #369586] Tue, 31 October 2000 01:19 Go to next message
Naresh Kakrani
Messages: 1
Registered: October 2000
Junior Member
Hi,

I am facing one problem while compiling one procedure at SQL Prompt.

0-06502 PL/SQL : Numeric or value error: Character to number conversion error.

0-06512 At "SCOTT.ABC", line 157
0-01578 Oracle Data Block Corrupted(file #2, block # 22774)
0-01110 data file 2 : 'F:\ORACLE\ORADATA\ORCL\RBS01.DBF'

Here
RBS01.DBF files are rollback segment files, We are using 10 RBS##.dbf files.

Please help me , how to recover these corrupted files.
Can we recreate it or create new one.

Regards

Kakrani

Report message to a moderator

Re: Data Block Corrupted in Rollback Segment [message #369588 is a reply to message #369586] Tue, 31 October 2000 06:50 Go to previous message
sudhakar k
Messages: 1
Registered: October 2000
Junior Member
u can drop the rb file and recreate it.
it is tough to recover in such a situation.
please let me know if ot works.

Report message to a moderator

Previous Topic: Oracle to Dbase conversion
Next Topic: Internal error PLS0707
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 27 01:09:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.