Restrictions on Analyzing Tables

Analyzing tables is subject to the following restrictions:
■ You cannot use ANALYZE to collect statistics on data dictionary tables.
■ You cannot use ANALYZE to collect statistics on an external table. Instead, you
must use the DBMS_STATS package.
■ You cannot use ANALYZE to collect default statistics on a temporary table.
However, if you have already created an association between one or more columns
of a temporary table and a user-defined statistics type, then you can use ANALYZE
to collect the user-defined statistics on the temporary table.
■ You cannot compute or estimate statistics for the following column types: REF
column types, varrays, nested tables, LOB column types (LOB column types are
not analyzed, they are skipped), LONG column types, or object types. However, if a
statistics type is associated with such a column, then Oracle Database collects
user-defined statistics.[@more@]