Archives of the TeradataForum

Message Posted: Fri, 18 May 2012 @ 10:05:59 GMT

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

<-- Anonymously Posted: Friday, May 18, 2012 03:53 -->

From the Messages manual:

ARC1027 The bounding condition for PPI table '%s.%s' is not considered to be 'well-defined'. Therefore, the ALL PARTITIONS option will not be allowed when doing a restore/copy.

Explanation: The database has determined that the bounding condition for the archived PPI table is not 'well-defined'. The implication of this determination is that the ALL PARTITIONS option will not be allowed when doing a restore/copy. This is because the bounding condition is not specific enough to determine which partitions must be deleted during the restore/copy operation.

For Whom: End User.

Notes: The bounding condition is generated by the database from the PARTITIONS WHERE option when the PPI backup of selected partitions is generated. It defines the logical scope of rows stored on the archive file. However, there are cases such as when the UNKNOWN partition is backed up where the restore semantics may be imprecise. A restore/copy that invokes the ALL PARTITIONS option uses the bounding condition stored on the archive file to define the logical scope of what partitions are deleted and restored so we want to ensure precise semantics. This particular warning message is generated at backup time to let you know that you will NOT be able to restore the backup using the ALL PARTITIONS option.

You can still restore selected partitions if you explicitly define the PARTITIONS WHERE option for the restore/copy statement.

Remedy: None.

HTH.

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