|
|
Archives of the TeradataForum
Message Posted: Tue, 29 Aug 2000 @ 16:58:03 GMT
Subj: | | Re: DBC.ACCESSRIGHTS error |
|
From: | | Roland Thomas |
I suggest that you talk to your NCR support before doing anything to dbc.accessrighs. Depending on the size of your table it may take a
very long time to copy and then re-insert due to the terrible primary index on the table. You can do a select userid,databaseid,count(*) to
see how badly skewed it is. On a small system it may not be too bad.
Roland Thomas
Sr. Consultant
NCR Corporation
| |