ORA-28664: a partitioned table may not be coalesced as a whole



ORA-28664: a partitioned table may not be coalesced as a whole..

Answer / guest

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)

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02468: Constant or system variable wrongly specified in expression

1 Answers  


ORA-00741: logfile size of (string) blocks exceeds maximum logfile size

1 Answers  


ORA-24773: invalid transaction type flags

1 Answers  


DRG-10579: must provide text query criteria

1 Answers  


ORA-13213: failed to generate spatial index for window object

1 Answers  






DRG-13100: index is not partitioned

1 Answers  


ORA-24127: TABLESPACE parameter specified with an ACTION other than CREATE_ACTION

1 Answers  


ORA-30942: XML Schema Evolution error for schema 'string' table string column 'string'

1 Answers  


ORA-02170: FREELIST GROUPS storage option not allowed

1 Answers  


TNS-12678: Authentication disabled but required

1 Answers  


ORA-12085: materialized view log on "string"."string" already has object id

1 Answers  


DRG-11623: URL store: unknown error getting string

1 Answers  


Categories