Validate Structure option of analyze

[nirasha]

Hi there,

Does anyone know what exactly does this validate structure validates??? We have brought over alot of parent and child records and they don't look right.. How do I check the integrity of my database?

Thanks,
Nirasha

[sreddy]

VALIDATE STRUCTURE validates the structure of the analyzed object. Oracle optimizer will not use these statistics unlike statistics collected by the COMPUTE STATISTICS and ESTIMATE STATISTICS clauses.

Validating the structure of an object prevents DML activity on the object. So, do not use this clause on the tables, clusters, and indexes of production applications during database activity which may lead to corruption of data/objects and endup recreating objects.

[Edited by sreddy on 01-18-2001 at 04:39 PM]

[marist89]

You want a different validate ( [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76965/c24integ.htm#4019[/url] )

[nirasha]

Right on target,

thanks alot.

Nirasha