René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
analyze table [Oracle SQL] | ||
Validating the structureanalyze 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.
|