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-01953: command no longer valid, see ALTER USER

1 Answers  


NZE-29039: There are no matching cipher suites.

1 Answers  


ORA-25471: attribute name not specified for variable: string

1 Answers  


PLS-00242: invalid external type specification for CONTEXT

1 Answers  


ORA-23416: table "string"."string" does not contain a primary key constraint

1 Answers  






ORA-27205: skgfpcn: sbtpccancel returned error

1 Answers  


NNL-00952: Cache lookup failures: number

1 Answers  


ORA-30349: specified dimension hierarchy does not exist

1 Answers  


ORA-24782: Cannot detach from a non-migratable transaction

1 Answers  


DRG-10202: server failed to register

1 Answers  


PCB-00310: AT clause is an Oracle extension

1 Answers  


PLS-00334: "string" matches table or view without an alias

1 Answers  


Categories