Oracle Database Errors or Warnings from Error ORA-10652 to ORA-10660

SQLServerF1

ORA-10652: Object has on-commit materialized views
Cause: It is illegal to issue shrink on an object with on-commit materialized views
Action: None
ORA-10653: Table is in a cluster
Cause: It is illegal to shrink a table belonging to a cluster
Action: None
ORA-10654: Table is of type temporary or external
Cause: It is illegal to shrink a temporary table or an external table
Action: None

ORA-10655: Segment can be shrunk
Cause: Error message returned when called in probe mode by OEM
Action: None
ORA-10656: Table is in unusable state due to incomplete operation
Cause: ALTER TABLE SHRINK operation was tried on the table which is in unusable state because of previously failed/incomplete operation.
Action: If the previous operation was
– DROP COLUMN, resubmit DROP COLUMN CONTINUE

– DROP TABLE, resubmit DROP TABLE <table> PURGE

ORA-10657: Lob column to be shrunk does not exist
Cause: Shrink was issued on a lob segment that did not exist
Action: None

ORA-10658: Lob column to be shrunk is marked unused
Cause: Shrink was issued on a lob segment that is marked as unused
Action: None
ORA-10659: Segment being shrunk is not a lob
Cause: Shrink was issued on a segment that should be a first class lob or other data type stored in lob
Action: None
ORA-10660: Segment is a shared lob segment
Cause: Shrink was issued on a segment that was being shared by multiple lob columns
Action: None

Above are list of Oracle Database Errors or Warnings from Error ORA-10652 to ORA-10660 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.

Thanks,
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 *