Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_DDL, 3 of 3
This procedure provides statistics for the given table, index, or cluster. It is equivalent to the following SQL statement:
ANALYZE TABLE|CLUSTER|INDEX [<schema>.]<name> [<method>] STATISTICS [SAMPLE <n> [ROWS|PERCENT]]
DBMS_DDL.ANALYZE_OBJECT ( type VARCHAR2, schema VARCHAR2, name VARCHAR2, method VARCHAR2, estimate_rows NUMBER DEFAULT NULL, estimate_percent NUMBER DEFAULT NULL, method_opt VARCHAR2 DEFAULT NULL, partname VARCHAR2 DEFAULT NULL);
Exception | Description |
---|---|
ORA-20000: |
Insufficient privileges or object does not exist. |
ORA-20001: |
Should be either |
ORA-20002: |
|
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|