[EMAIL PROTECTED]
[EMAIL PROTECTED] cc:
om Subject:
Corrupt block in DBVERIFY
Sent
. That it is an slowly view.
Regards.-
--- Smith, Ron L. [EMAIL PROTECTED] wrote:
I have a corrupt block according to DBVERIFY. The
block is on an index so I
can rebuild it but I don't know how to find the
object with the information
displayed in DBVERIFY. Can anyone tell me how to
find the object?
Thanks
[EMAIL PROTECTED]
[EMAIL PROTECTED] cc:
om Subject:
Corrupt block in DBVERIFY
Sent
I have a corrupt block according to DBVERIFY. The block is on an index so I
can rebuild it but I don't know how to find the object with the information
displayed in DBVERIFY. Can anyone tell me how to find the object?
Thanks!
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
]]
Sent: Monday, July 09, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L
Subject: Corrupt block in DBVERIFY
I have a corrupt block according to DBVERIFY. The block is on an index so
I
can rebuild it but I don't know how to find the object with the
information
displayed
I think you can run an analyze index validate structure on all the indexes
in the tablespace associated with that datafile. Once you identify the
corrupted index(es), you can drop/recreate them.
Jim
I have a corrupt block according to DBVERIFY. The block is on an index so
I
can rebuild
I think you can run an analyze index validate structure on all the indexes
in the tablespace associated with that datafile. Once you identify the
corrupted index(es), you can drop/recreate them.
Jim
I have a corrupt block according to DBVERIFY. The block is on an index so
I
can rebuild
. To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
[EMAIL PROTECTED] cc:
om Subject: Corrupt block in DBVERIFY
[EMAIL PROTECTED] wrote:
Ron,
Was the database open when you ran dbverify?
If so, run it on the file again and see if it still reports corruption.
I've done this a number of times on an open database. When
a corruption was found, running dbverify a second time would
show that the file