 |
 |
Archives of the TeradataForum
Message Posted: Fri, 31 Aug 2012 @ 09:49:39 GMT
| Subj: | | Re: Copy data from backup |
| |
| From: | | Machha Narayan Rao Naidu |
Roopalini Bakthavachalam wrote:
| | Could you please explain what exactly this script does? I am kind off confused. Does it COPY back to a different table in the DB from the
backup. | |
Newell, Ray wrote:
| | The database must exist on the target, the copy command will not create it. ?If the tables do not exist on the target, copy will create
them. ?If the target tables already exist, copy will drop and create the tables on the target based on the definition on the tape. ? So any of the
existing table definitions on target that are different will be lost. ?Note, if the table already exists on the target, you will get a warning
message. ?This is simply for you to know that whatever definition you had on the target prior to the copy was replaced by the copy. | |
Hope it helps.
Thanks
Machha
| |
