Table-level restore syntax

Deployment options: Netezza Performance Server for Cloud Pak for Data System Netezza Performance Server for Cloud Pak for Data

To run a table-level restore, use the following syntax:
nzrestore -db <dbname> -connector <filesystem> -dir <root dir> 
[<opts>] -tables <table1> [ ...]
Note: If you specify multiple tables with the -tables option, separate the table names with spaces.

As in a standard restore, by default the system restores the table's definition and data. To skip the data restore, use the -noData option.

Keep in mind the following behaviors:
  • You can specify the nzrestore command-line options in any order.
  • If your table names contain spaces, enclose the names in double quotation marks.
  • If your table names begin with dashes (-), you can restore them by listing them in a single file and by using the -tablefile option.
  • You can restore to a different target database than the original backup (use the -sourcedb option to find the backup).
  • If the target database does not exist, the system creates it.
  • Specify the table name in the letter case form (uppercase or lowercase) that matches the name in the backup set.
  • If the backup set for a database includes multiple schemas, and the table name is not unique because it is used in more than one schema, the system displays the message Error: More than one table having name 'TABLENAME' found in the backup. Specify -sourceschema option. You must specify the schema where the table is defined in the backup set to uniquely identify the table.
  • If the table exists in the database with the same name as the table you are restoring, both copies of the table exist until the transaction is complete. If there is not enough disk space for both versions of the table, you must manually drop the table before you run the table-level restore.