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

PCB-00208: Incorrect type for host variable "string"

1 Answers  


ORA-32818: AQ queue string does not exist

1 Answers  


ORA-38462: invalid attribute list

1 Answers  


LPX-00208: unknown DTD keyword "~s"

1 Answers  


PLS-00900: can't find body of unit 'string'

1 Answers  






PLS-00593: default value of parameter "string" in body must match that of spec

1 Answers  


ORA-33450: (ESDREAD05) Discarding compiled code for workspace object because number now has more or fewer dimensions than it had when the code was compiled.

1 Answers  


ORA-39005: inconsistent arguments

1 Answers  


SQL*Loader-00120: Invalid _synchro option string

1 Answers  


ORA-13765: Value "string" is illegal for a result limit.

1 Answers  


RMAN-06466: error parsing configuration string (string)

1 Answers  


NNL-00306: Server setting all statistic counters to zero

1 Answers  


Categories