|Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
CREATE SYNONYM to DROP ROLLBACK SEGMENT, 12 of 31
STATISTICS statement to disassociate a statistics type (or default statistics) from columns, standalone functions, packages, types, domain indexes, or indextypes.
See Also: ASSOCIATE STATISTICS for more information on statistics type associations
To issue this statement, you must have the appropriate privileges to alter the base object (table, function, package, type, domain index, or indextype).
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 to delete 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