René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

analyze table [Oracle SQL]

Validating the structure

analyze table table-name validate structure 
analyze table table-name validate structure online
analyze table table-name validate structure cascade
analyze table table-name validate structure cascade online
This command validates the integrity of the db blocks of the underlying table.
If cascade is specified, the command also checks the index
ORA-01499 is thrown if the validation fails.
analyze table requires a temporary segment if the statement cannot be completed in memory.