Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 28 Jan 2005 @ 16:54:49 GMT


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


Subj:   Re: Maximum Limits of Users in Warehouse
 
From:   Dieter Noeth

McBride, Michael wrote:

  The reference David made was to only restore the DBC and not the actual restore of the userdbs. In order for a true re-creation of an entire instance of Teradata, you need to restore both the DBC AND all the databases (including users databases).  


The databases/users are recreated by a dbc restore, but they're empty. You just have to restore the tables.

But a problem would be any views/macros within a user: if they're not backed up and restored there will be some entries within the dbc.accessrights for those missing objects.


  Note: I see a problem if you only restore the dbc and not the users in from the archive. You may have a problem with a create user statement, if the dbc thinks that user already exist.  


IMHO dbc doesn't *think* it exists, it *really* exists after the dbc restore ;-)


  I have never tried to create a user after a restore of the DBC without a restore of the users databases as well.  


I never restored dbc, but maybe i should try it once ;-)


Dieter



     
  <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: 28 Jun 2020