OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » analyze table....

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

analyze table.... [message #163683]

Fri, 17 March 2006 23:15

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi,

For block corruption I'm running a commanf like

Analyze table table1 validate structure

Now how to know the output of it. i.e there are any block corruption or not?

Brayan.

Report message to a moderator

Re: analyze table.... [message #163776 is a reply to message #163683]

Sun, 19 March 2006 19:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Now how to know the output of it. i.e there are any block corruption or not?
Wrong "tool" for the job.
Use standalone "dbv" utility ( or RMAN).

Report message to a moderator

Re: analyze table.... [message #163784 is a reply to message #163776]

Mon, 20 March 2006 00:00

Brayan
Messages: 315
Registered: June 2002

Senior Member

see the below given link.
http://www.adp-gmbh.ch/ora/sql/analyze_table.html

My question was after validation how to check the result.

Brayan

Report message to a moderator

Previous Topic:	tablespace with nologging mode
Next Topic:	Archival has been disabled due to space problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 18 19:01:17 CST 2025