 |
 |
Archives of the TeradataForum
Message Posted: Fri, 28 Jan 2005 @ 15:45:31 GMT
| Subj: | | Re: Maximum Limits of Users in Warehouse |
| |
| From: | | McBride, Michael |
Hey, David, your right in that the DBC restore would have a;; the definitional info for each of the users, however, it will not actually have
re-created the userdb necessary to exist in order to log onto the database. Therefore, if you don't actually restore the individual userdbs you
will have to re-create then from a script, even it that script is created on the fly from the dbc tables. You would still incur the overhead of
executed the create user statement (in this case 750,000 times). Which will delay your recovery.
Michael E. McBride
Teradata Certified Master
Teradata Database Administrator
Data Architect and Data Warehouse Practitioner
American Eagle Outfitters
| |
