Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 31 Aug 2012 @ 20:56:38 GMT


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


Subj:   Re: Copy data from backup
 
From:   Bakthavachalam, Roopalini

Hi Manish,

I first took a dump of Database A - named it FRI. I am now trying to use the below script and copy the database A to database B using the THUR_1 dump.

     LOGON  10.24.15.207/DBC,"m1cr0sup3rus3r!";
     COPY DATA TABLES(database_B) (FROM (database_A))
     FILE=FRI,
     RELEASE LOCK;
     LOGOFF;

I am running the above script using a bat file , however getting the below error.

     Failure ARC0202:FILE was not expected.
     08/31/2012 15:22:50  LOGGED OFF   3 SESSIONS
     08/31/2012 15:22:50  ARCMAIN TERMINATED WITH SEVERITY 12

What could cause the error??


Thanks

Roopalini



     
  <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