Archives of the TeradataForum

Message Posted: Thu, 02 Aug 2012 @ 23:02:45 GMT

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

You don't need to delete the data on the target system.....COPY will actually drop and recreate the table structure for you....so if your table happened to have a different structure on the target (say a missing column), COPY to will replace it with the table structure from the source. It will also bring over any statistics you had on the tables.

What I don't remember is what would happen if you had an extra table in the target database and you did a database level COPY ....that extra table may get dropped, but as I said, I don't remember.

Ruth

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