Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Jun 2006 @ 14:04:16 GMT


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


Subj:   Re: How to archive more than one tables from a database
 
From:   Victor Sokovin

  When I want to archive more than 1 tables from the database I typed the following code:  


          > LOGON 172.16.134.3/dbc ,dbc;
          > ARCHIVE DATA TABLEs (DBname.TableName1, DBname.TableName2) ,
          > RELEASE LOCK,
          > FILE=check;
          > LOGOFF;

I think Teradata expects to find between brackets either a table name or a database name, not a comma separated list of objects.

Try something like this instead:

     ARCHIVE DATA TABLEs (DBname) EXCLUDE TABLES (DBname.TableName3,
     DBname.TableName4) ,
     RELEASE LOCK,
     FILE=check;

Regards,

Victor



     
  <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