Archives of the TeradataForum

Message Posted: Tue, 06 Mar 2002 @ 00:09:15 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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:

Answer:

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.

Jacques Cayo
Servicio Gesti�n de Informaci�n
Banco de Cr�dito del Per�

	<Prev	Next>		<<First	<Prev	Next>	Last>>