Syntax - Teradata Tools and Utilities

where:

DATA TABLE

DATA TABLES

Restores both fallback and non-fallback tables to all AMPs or clusters of AMPs.

DICTIONARY TABLE

DICTIONARY TABLES

Restores only dictionary rows.

This option is only allowed for:

• Archives created using the DICTIONARY option of the ARCHIVE statement
• All-AMPs journal archives

NO FALLBACK TABLE

NO FALLBACK TABLES

Restores tables without fallback to complete a previous all-AMPs or cluster restore where AMPs were offline, or to restore non-fallback data to specific AMPs recovering from disk failure.

JOURNAL TABLE

JOURNAL TABLES

Restores an archived journal for subsequent use in a roll operation.

ALL FROM ARCHIVE

Specifies that all databases and tables in the given archive file will be restored and that any existing databases and tables will be overwritten.

This option is used in place of database/table names normally specified.

No other database or table names can be specified to be restored with this option.

(dbname)

Name of the database to restore.

This form restores all tables of the type specified, and all stored procedures (if specified type is FALLBACK) that are in the named database and on the input file.

ALL

Restores the named database and all descendants.

(dbname.tablename)

Name of a table within the named database to restore.

All tables should be distinct within the list. Duplicate table names are ignored.

EXCLUDE

Prevents specified databases from being restored.

(xdbname)

Name of database to exclude from restore.

ALL

Excludes the named database and all descendants.

(xdbname1) TO (xdbname2)

Alphabetical list of client databases to exclude from the restore.

The delimiting database names need not identify actual databases.

Database DBC is not part of a range.

CLUSTERS = nnn

CLUSTER = nnn

Specifies AMP clusters to restore.

nnn is the cluster number.

Specify up to 4096 clusters.

AMP = n

Specifies the AMP (or a list of AMPs) to restore for Teradata Database, where n is the number of the AMP.

Specify up to five AMPs with this option.

RESTORE FALLBACK

Restores the fallback copy of primary and unique secondary indexes while restoring the data.

This option applies only to data table restores of fallback tables.

When the RESTORE FALLBACK option is specified and the system formats or hash functions of the source and target systems are different. Teradata ARC disables the RESTORE FALLBACK request.

NO BUILD

Prevents the Fallback and Secondary Index rows from being created.

If NO BUILD is requested when restoring database DBC, the request will be ignored.

If the NO BUILD keywords are used during a RESTORE statement, a separate BUILD statement must be run for all databases and/or tables that were restored. The tables will not be accessible until a BUILD statement is run.

RELEASE LOCK

Releases utility (HUT) locks on the named databases when the restore completes successfully.

ABORT

Aborts the restore if an AMP to which a non-fallback table is to be restored is not online.

This option affects only an all-AMPs restore. It does not affect a specific AMP restore.

EXCLUDE TABLE

EXCLUDE TABLES

prevents individual objects in the listed database from being restored.

(xtablename)

Name of an individual object in the designated database to exclude.

Multiple objects are separated by commas.

This form (without a database name prefix) is used only when ALL has not been specified for the current object.

(xdbname.xtablename)

List of fully qualified objects (prefixed by database name) to exclude.

PARTITIONS WHERE

Specifies the conditional expression for partition-level operations.

(!conditional expression!)

The conditional expression for specifying selected partitions.

LOG WHERE

Specifies the rows that are logged to an error table for manual insertion and deletion.

(!conditional expression!)

The conditional expression for specifying rows to log to the error table when restoring selected partitions.

ALL PARTITIONS

Restores all archived partitions for an archived PPI object.

QUALIFIED PARTITIONS

Restores the same partitions specified in a previous selected-partition restore.

ERRORDB

ERRORTABLES

Specifies the location of the error log for partition-level operations.

DBSIZEFILE

Prompts Teradata ARC to read the file specified in filename for the desired perm space for each specified database or user.

Resizing the Teradata Database with DBSIZEFILE has more information.

filename

Specifies the name of the text file that contains pairs of database or user names and sizes.

The information is used in resizing a database.

SKIP JOIN INDEX

Skip the restore of join and hash indexes.

SKIP STAT COLLECTION

Skip the restore of Stat Collections.