![]() |
|
![]() |
![]() |
Archives of the TeradataForumMessage Posted: Mon, 18 Jul 2011 @ 12:38:26 GMT
<-- Anonymously Posted: Monday, July 18, 2011 08:14 --> Hi , Yes that will probably work but my archive script looks a bit different :-) My backup is taken with the a script like you can see below: .logon TDPID/username,passwd; ARCHIVE DATA TABLES (db_old.table), (db_old.table2), .... (db_old.table_n), RELEASE LOCK, FILE=ARCHIVE; .logoff; I need to copy 1 partition of 2 tables within that archive : - Db_old.table And this needs to done into another database db_new. I try do the copy via the following ARC main script: COPY DATA TABLE (db_new.table) (PARTITIONS WHERE (! x=106 !), FROM(db_old.table)), RELEASE LOCK, FILE=ARCHIVE; According to the books this should be possible. (or at least that's what I understood by reading it.) But I'm getting the errors I explained earlier. Regards,
| ||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
![]() | ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||