Archives of the TeradataForum

Message Posted: Mon, 18 Jul 2011 @ 10:14:56 GMT

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

Hi

I am new to this arcmain utility. But I think you have done some thing wrong in the script. Please try to remove the " FROM(db_old.table)), " in your script and then try.

So the new script will be :-

     COPY DATA TABLE
       (db_new.table)
       (PARTITIONS WHERE (! x=106 !)),
       RELEASE LOCK,
       FILE=ARCHIVE;

I have given this script assuming that you have taken the archive in the file called as ARCHIVE. If still you are facing problem, please send the new error code and the archive script and the restore script also.

Thanks,

Asim

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