Oracle Database Errors or Warnings from Error ORA-28653 to ORA-28664

ORA-28653: tables must both be index-organized
Cause: Attempt to exchange a non IOT table/partition with a partition/table respectively
Action: Ensure that non-partitioned and partitioned tables are both index-organized.
ORA-28654: table and partition not overflow compatible
Cause: If one of the tables (partitioned/non-partitioned) has overflow data segment and the other one doesn’t.
Action: Ensure that non-partitioned and partitioned tables both have overflow data segment or neither one does.
ORA-28655: Alter table add overflow syntax error
Cause: Syntax error
Action: Check the syntax.

ORA-28656: incomplete attribute specification
Cause: The attribute specification is not done for all partitions”
Action: Specify the storage attributes either for ALL partitions or NONE NLS_DO_NOT_TRANSLATE [28657,28657]
ORA-28658: This operation is supported only for Index-Organized tables
Cause: Attempt to perform some IOT specific operation on a non-IOT
Action: don’t do this. This is not supported
ORA-28659: COMPRESS must be specified at object level first
Cause: Attempt to specify COMPRESS at partition level without first specifying at the table level
ORA-28660: Partitioned Index-Organized table may not be MOVEd as a whole
Cause: Attempt to MOVE partitioned IOT as a whole
Action: don’t do this. This is not supported

ORA-28661: Object already has COMPRESS clause specified
Cause: Attempt to specify compress for iot/index which already has a compression clause.
Action: This is a ‘create time only’ attribute
ORA-28662: IOT index and overflow segments must share the same LOGGING attribute
Cause: Attempt to specify LOGGING for one segment and NOLOGGING for the other segment.
Action: don’t do that
ORA-28663: Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW
Cause: Attempt to specify LOGGING for a Alter Table Add Overflow.
Action: don’t do that
ORA-28664: a partitioned table may not be coalesced as a whole
Cause: User attempted to coalesce a partitioned IOT using ALTER TABLE COALESCE statement, which is illegal
Action: Coalesce the table a partition at a time (using ALTER TABLE MODIFY PARTITION COALESCE)

Above are list of Oracle Database Errors or Warnings from Error ORA-28653 to ORA-28664 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *