SQL/MP Messages Manual

SQL Catalog Manager Messages (1000 to 1999)
HP NonStop SQL/MP Messages Manual—427720-006
3-10
SQL 1070
Cause. The USAGES table contains the objects that are dependent on the reused
partition.
Effect. The statement fails. The partition to be reused is intact.
Recovery. Drop the dependent objects and reissue the statement.
SQL 1071
Cause. REUSE PARTITION can be performed only on a partition that is not the
primary partition.
Effect. The statement fails. The partition to be reused is intact.
Recovery. Correct the statement. For a partitioned table, verify that the object name
identifies a partition that is not the primary partition.
SQL 1072
Cause. Format 2 partitions are not supported for relative and entry-sequenced tables.
Effect. The statement fails.
Recovery. Reissue the statement specifying a key-sequenced table.
SQL 1073
Cause. Stated in the error message.
Effect. The statement fails.
Recovery. Reissue the statement specifying a key-sequenced table that does not
contain a Format 2 partition.
1070 The reused partition has the dependent object value. A
reused partition cannot have any dependent objects.
1071 ALTER TABLE...REUSE PARTITION cannot be performed
against the primary partition of a partitioned table.
FORMAT 2 and partition array value "FORMAT2ENABLED" can only
be specified for key-sequenced tables.
Unable to modify the partition array from "FORMAT2ENABLED" to
"STANDARD" or "EXTENDED" since the table or one of its
indexes contains a Format 2 partition.