Archives of the TeradataForum

Message Posted: Fri, 28 Jul 2006 @ 15:32:29 GMT

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

Individual views cannot be restored - they must be restored as part of a database/user restore.

We save all current view DDL offline so we can recreate view definitions individually if necessary.

Use the COPY command to restore your user objects.

SYNTAX EXAMPLE:

     logon $LOGON;
     copy data table
        (Superman),
     release lock,
     file=NVDS1;
     logoff;

Because the target user/database must exist in the Data Dictionary to use COPY, we must CREATE USER Superman first. Then we can copy the objects from the archive.

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