15.00 - Rules for Using Client Archive and Load Utilities With A Column-Partitioned Table - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Rules for Using Client Archive and Load Utilities With A Column-Partitioned Table

  • You cannot load rows into a column‑partitioned table using the MultiLoad or FastLoad utilities.
  • You can load rows into a column‑partitioned table using Teradata Parallel Data Pump array INSERT operations.
  • You can also use INSERT … SELECT requests to load rows from a source table into a column‑partitioned target table. The source can be a primary‑indexed table, a column‑partitioned table, or an unpartitioned NoPI table.

    See Teradata Parallel Data Pump Reference and Database Design for more information about using the Teradata Parallel Data Pump utility to load rows into a column‑partitioned table.

  • The following rules apply to using the Archive/Recovery utility with column‑partitioned tables.
  • You can archive, restore, and copy a column‑partitioned table with column partitioning or row partitioning or both.
  • You can also archive, restore, and copy databases or users that contain column‑partitioned tables.

  • You cannot archive, restore, or copy selected partitions of a column‑partitioned table.
  • You should not archive, restore, or copy selected partitions of a column‑partitioned table.
  • This is valid for 2‑byte partitioning, but it is a deprecated feature.

    You cannot archive, restore, or copy selected partitions of an column‑partitioned table with 8‑byte partitioning.