where:
- DATA TABLE or DATA TABLES
- Copies data tables.
- DICTIONARY TABLE or DICTIONARY TABLES
- Copies dictionary tables.
- JOURNAL TABLE or JOURNAL TABLES
- Copies journal tables.
- NO FALLBACK TABLE or NO FALLBACK TABLES
- Copies non-fallback tables to specific AMPs.
- ALL FROM ARCHIVE
- Copies all databases/tables in the given archive file.
- EXCLUDE
- Prevents specifeid databases from being copied.
- (dbname)
- Name of database to exclude from copy.
- ALL
- Excludes the named databse and all descendants.
- (xdbname1) TO (xdbname2)
- Alphabetical list of client databases to exclude from the copy.
- (dbname) or (dbname.tablename)
- Name of target object.
- FROM
- Name of the source object when copying to a different location or name on the target system.
- NO FALLBACK
- Copies fallback tables into non-fallback tables.
- REPLACE CREATOR
- Replaces the LastAlterUID, creator name, and Creator ID of the tables in the target database with the user ID and the current user name, i.e., the user name specified in the LOGON command.
- NO JOURNAL
- Copies all tables with journaling disabled, whether journaled in the archive or not.
- WITH JOURNAL TABLE
- Specifies that a copied database has journaling for the specified database and journal table.
- APPLY TO
- Identifies the tables in the target system where the change images apply.
- NO BUILD
- Prevents the Fallback and Secondary Index rows from being created.
- ABORT
- Aborts the copy operation if an AMP to which a non-fallback or journal table to restore is offline.
- RELEASE LOCK
- Releases client utility locks when the copy operation completes.
- FILE
- Copies a file.
- name
- Name of the file that contains the archive to copy.
- EXCLUDE TABLE or EXCLUDE TABLES
- Prevents individual objects in the listed database from being copied.
- (xtablename)
- Name of an individual object in the designated database to exclude
- (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 copying selected partitions.
- ALL PARTITIONS
- Restores all archived partitions for an archived PPI object.
- QUALIFIED PARTITIONS
- Copies the same partitions specified in a previous selected-partition copy.
- ERRORDB and ERRORTABLES
- Specifies the location of the error log for partition-level operations.
- SKIP JOIN INDEX
- Skip the creation of join and hash indexes.
- SKIP STAT COLLECTION
- Skip the copy of Stat Collections.