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!

ANALYZE TABLE scott.emp VALIDATE STRUCTURE CASCADE;

ronald_2017Mar 29 2017 — edited Mar 29 2017

Hi All,

It has been said that ANALYZE TABLE command has been deprecated.

So, What is the following command equilavent?

I use it in order to find corrupted data block, can I use it for thias purpose?

ANALYZE TABLE scott.emp VALIDATE STRUCTURE CASCADE;

Thanks in advance

This post has been answered by Hemant K Chitale on Mar 29 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 26 2017

Added on Mar 29 2017

#general-database-discussions

6 comments

695 views