Home » RDBMS Server » Server Administration » analyze to get corrupted blocks
analyze to get corrupted blocks [message #61016] Sat, 20 March 2004 05:22 Go to next message
ashokmote
Messages: 56
Registered: December 2003
Member
by analyzing we can get the corrupted blocks information.

sql>analyze table customer validate structure;

this command will find the corrupted blocks and adds tha suspect rows to invalid_rows table.

but were can i get this invalid_rows table.

which script i have to run to get this invalid_rows table.

can i create it manually.if yes wat is the procedure.

Report message to a moderator

Re: analyze to get corrupted blocks [message #61017 is a reply to message #61016] Sat, 20 March 2004 09:26 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

If I remember correctly - @?/rdbms/admin/utlvalid.sql

Best regards.

Frank

Report message to a moderator

Previous Topic: ORA-00405: compatibility type "LOB Retention"
Next Topic: How to connection Oracle database through ODBC DSN
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:54:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.