Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
SQL Statements:
CREATE TYPE to
DROP ROLLBACK SEGMENT, 7 of 26
Use the DISASSOCIATE
STATISTICS
statement to disassociate a statistics type (or default statistics) from columns, standalone functions, packages, types, domain indexes, or indextypes.
To issue this statement, you must have the appropriate privileges to alter the base object (table, function, package, type, domain index, or indextype).
disassociate_statistics::=
disassociate_statistics
Specify one or more columns, standalone functions, packages, types, domain indexes, or indextypes from which you are disassociating statistics.
If you do not specify schema, Oracle assumes the object is in your own schema.
If you have collected user-defined statistics on the object, the statement fails unless you specify FORCE
.
Specify FORCE
to remove the association regardless of whether any statistics exist for the object using the statistics type. If statistics do exist, the statistics are deleted before the association is deleted.
This statement disassociates statistics from the pack
package in the hr
schema:
DISASSOCIATE STATISTICS FROM PACKAGES oe.emp_mgmt;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|