Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 13 Oct 2010 @ 13:24:49 GMT


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


Subj:   Re: ARC/RESTORE: - Copy database with No data.
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, October 13, 2010 09:23 -->

From Arcmain I tried as below.

Source system

     archive dictionary tables (DB), release lock,file=dd;

Target system

     copy  dictionary tables (DB), release lock,file=dd;

--> This is another option but the target restore is giving 2654. Any ideas.?

--> Show table gives the DDL fine, It is only select comlains.

Below is from target system

      BTEQ -- Enter your SQL request or BTEQ command:
     sel * from DB.t3;

      *** Failure 2654 Operation not allowed: DB.t3 is being Restored. <---
                     Statement# 1, Info =0
      *** Total elapsed time was 1 second.

      BTEQ -- Enter your SQL request or BTEQ command:
     show table DB.t3;

      *** Text of DDL statement returned.
      *** Total elapsed time was 1 second.

     -------------------------------------------------------
     CREATE SET TABLE DB.t3 ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
          (
           i INTEGER,
           j INTEGER,
           k INTEGER)
     PRIMARY INDEX ( i );

Archive/Restore experts any inputs please. I tried an override & release lock from BTEQ.


Regards.



     
  <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