Archives of the TeradataForum
Message Posted: Tue, 06 Mar 2002 @ 00:09:15 GMT
Short Description: Why Can't I Collect Statistics On DBC Tables? BM__Section1_1 www.san101ln.sandiegoca.ncr.com... +Composition Details www.san101ln.sandiegoca.ncr.com... Product Category: OS/Applications / Teradata DBS (All Operating Systems) Product: Tdat_SQL / www.san101ln.sandiegoca.ncr.com... Question: Why can't I collect statistics on dbc tables? collect statistics on dbc.accessrights; *** Failure 3523 The user does not have DROP TABLE access to DBC.AccessRights. Configuration Data:
Problem Solution/Problem Prevention:Statistics are never collected on system tables. Why?
Because a user must have the DROP TABLE right on a table in order to be allowed to collect statistics on it. No user - including DBC - has the DROP TABLE right on tables in user DBC. This is intentional. We do not want it to be possible for a system table to be dropped by mistake.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|