Can't access SOME table's statistics.

From: Robert Wagner <RobertWagner_at_alum.mit.edu>
Date: 2000/07/31
Message-ID: <7dkh5.28384$9E6.161474@newsr1.maine.rr.com>#1/1

I presently have 8 tables in a schema. When I do a SELECT on USER_TABLES I see all
of them, but I don't get anything in statistical columns like NUM_ROWS, BLOCKS,
EMPTY_BLOCKS, and AVG_SPACE for three of the tables. Is there something like (this is pure speculation):

ENABLE STATISTICS_COLLECTION ON mytable

that would be required to for this data to be collected?

When I do an export from the schema, the CREATE TABLE statements don't seem different in any
way that could explain this.

TIA >>> Robert (still being surprised by Oracle) Received on Mon Jul 31 2000 - 00:00:00 CDT