The difference between copy and restore depends on the kind of operation being performed:
- A restore operation moves data from archived files back to the same Teradata Database from which it was archived or moves data to a different Teradata Database so long as database DBC is already restored.
- A copy operation moves data from an archived file to any existing Teradata Database and creates a new object if one does not already exist on that target database.
The target object does not have to exist, however, the database must already exist.
When selected partitions are copied, the table must exist and be a table that was previously copied as a full-table copy.