Archives of the TeradataForum

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

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

<-- 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>>