Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_UTILITY , 3 of 23
This procedure analyzes all the tables, clusters, and indexes in a schema.
DBMS_UTILITY.ANALYZE_SCHEMA ( schema VARCHAR2, method VARCHAR2, estimate_rows NUMBER DEFAULT NULL, estimate_percent NUMBER DEFAULT NULL, method_opt VARCHAR2 DEFAULT NULL);
Exception | Description |
---|---|
ORA-20000 |
Insufficient privileges for some object in this schema. |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|