Cause: User attempted to rebuild a partition of a Composite
Range partitioned index which is illegal

Action: none

Please add more information about this Error

Cause: The index in a partition or subpartition maintenance
operation (ALTER INDEX MODIFY [SUBPARTITION|DEFAULT
ATTRIBUTES FOR PARTITION] or ALTER INDEX REBUILD
SUBPARTITION command must be partitioned by Composite Range
method

Action: none

Please add more information about this Error

Cause: User attempted to rebuild a partition of a Composite
Range partitioned index which is illegal

Action: REBUILD the index partition, a subpartition at a time

Please add more information about this Error

Cause: A COALESCE SUBPARTITION command was issued when there
is only one subpartition in the partition which is illegal

Action: Ensure that there is at least one subpartition. Drop
partition to remove all subpartitions.

Please add more information about this Error

Cause: A COALESCE PARTITION command was issued when there is
only one partition in the table or index, which is illegal

Action: Ensure that there is at least one partition. Drop
the table or index to remove all partitions.

Please add more information about this Error

Cause: User issued ALTER TABLE statement attempting to
modify an existing VARCHAR2 (or VARCHAR) column to be of
type CHAR (or CHARACTER), increase length of an existing
CHAR (or CHARACTER) column, or add a column with
user-specified default for a table one or more subpartitions
of which reside in read-only tablespaces, which is illegal

Action: Avoid performing aformentioned operations on a
partitioned table one or more subpartitions of which reside
in read-only tablespaces

Please add more information about this Error

Cause: One of the tables named in the ALTER TABLE EXCHANGE
SUBPARTITION command has a UNIQUE constraint for which no
matching (vis-a-vis key columns) constraint is defined on
the other table or a matching constraint is defined on the
other table, but it differs from that defined on the first
table vis-a-vis being enabled and/or validated.

Action: Ensure that for every UNIQUE constraint defined on
one of the tables named in the ALTER TABLE EXCHANGE
SUBPARTITION statement there is a matching (vis-a-vis key
columns and being enabled and/or validated) UNIQUE
constraint defined on the other table. If UNIQUE constrains
are enabled, UNIQUE constraints on the partitioned table
should be enforced using local indexes.

Please add more information about this Error

Cause: The corresponding columns in the tables specified in
the ALTER TABLE EXCHANGE SUBPARTITION statement have
different FOREIGN KEY constraints.

Action: Ensure that the two tables do not have FOREIGN KEY
constraints defined on any column or disable all FOREIGN KEY
constraints on both tables. Then retry the operation.

Please add more information about this Error

Cause: The corresponding columns in the tables specified in
the ALTER TABLE EXCHANGE SUBPARTITION statement have CHECK
constraint defined on them.

Action: Ensure that the two tables do not have CHECK
constraint defined on any column

Please add more information about this Error

Cause: There is at least one row in the non partitioned
table which does not qualify for the subpartition specified
in the ALTER TABLE EXCHANGE SUBPARTITION

Action: Ensure that all the rows in the segment qualify for
the subpartition. Perform the alter table operation with the
NO CHECKING option. Run ANALYZE table VALIDATE on that
subpartition to find out the invalid rows and delete them.

Please add more information about this Error

Cause: The two tables specified in the ALTER TABLE EXCHANGE
SUBPARTITION have indexes which are not equivalent

Action: Ensure that the indexes for the two tables have
indexes which follow this rule For every non partitioned
index for the non partitioned table, there has to be an
identical LOCAL index on the partitioned table and vice
versa. By identical, the column position, type and size have
to be the same.

Please add more information about this Error

Cause: The corresponding columns in the tables specified in
the ALTER TABLE EXCHANGE SUBPARTITION are of different type
or size

Action: Ensure that the two tables have the same number of
columns with the same type and size.

Please add more information about this Error

Cause: The two tables specified in the ALTER TABLE EXCHANGE
SUBPARTITION have different number of columns

Action: Ensure that the two tables have the same number of
columns with the same type and size.

Please add more information about this Error

Cause: The table in the ALTER TABLE EXCHANGE SUBPARTITION
operation is either clustered or partitioned

Action: Ensure that the table with which the subpartition is
being exchanged for is not partitioned or clustered.

Please add more information about this Error

Cause: User attempt to reuse lower-bound partition of the
partitions being merged which is illegal

Action: Specify new resulting partition name or reuse the
higher-bound partition only

Please add more information about this Error