Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 28 Jul 2006 @ 15:32:29 GMT


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


Subj:   Re: Proper method to restore a View?
 
From:   Dye, Lisa

Individual views cannot be restored - they must be restored as part of a database/user restore.

We save all current view DDL offline so we can recreate view definitions individually if necessary.

Use the COPY command to restore your user objects.

SYNTAX EXAMPLE:

     logon $LOGON;
     copy data table
        (Superman),
     release lock,
     file=NVDS1;
     logoff;

Because the target user/database must exist in the Data Dictionary to use COPY, we must CREATE USER Superman first. Then we can copy the objects from the archive.



     
  <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