Archives of the TeradataForum

Message Posted: Mon, 18 Jul 2011 @ 13:35:46 GMT

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

I am not sure here but it looks like you might have things out of order, and I am assuming that this was an all amp backup that was taken.

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

It is worth a try I guess. There is also no telling how it handles the spaces between ! And x and x=106 !. You may need to remove these spaces (!x=106!).

KRT

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