Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 17 Dec 2003 @ 18:54:01 GMT


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


Subj:   Restore problem
 
From:   Kaul, Rohit

Hi All,

I'm trying to restore a table which has been dropped. While performing restore from archive I'm encountering an error:

---------------------------------------------------------------
12/17/2003 13:40:47  RESTORE DATA TABLES (DWTABLES_DEV.stub_tmp),
12/17/2003 13:40:47  RELEASE LOCK,
12/17/2003 13:40:47  FILE = X;
12/17/2003 13:40:47  LOGGED ON   10 SESSIONS
12/17/2003 13:44:33  *** Error 3807:Table/view/trigger/procedure 'STUB_TMP' does not exist.
12/17/2003 13:44:33  DWTABLES_DEV.STUB_TMP - TABLE SKIPPED.
12/17/2003 13:44:56  STATEMENT COMPLETED
12/17/2003 13:44:56
12/17/2003 13:44:56  LOGOFF;
12/17/2003 13:44:58  LOGGED OFF  12 SESSIONS
12/17/2003 13:44:58  STATEMENT COMPLETED
--------------------------------------------------------------

Also this is the restore script that I'm using:

LOGON $LOGON;
restore data tables (dwtables_dev.stub_tmp),
release lock,
file=x;
LOGOFF;
-------------------------------------------------------

We're using Netbackup 3.4 for our backup/restore


Rgds,

Rohit



     
  <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: 27 Dec 2016