Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 28 Jan 2005 @ 15:45:31 GMT

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

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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023