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-16086: standby database does not contain available standby log files

1 Answers  


ORA-38760: This database instance failed to turn on flashback database

1 Answers  


QSM-02141: the reason why the capability is disabled has escaped analysis

1 Answers  


ORA-27204: skgfpqr: sbtpcqueryrestore returned error

1 Answers  


ORA-25240: message ID and dequeue condition/correlation ID specified in dequeue options

1 Answers  






ORA-01540: tablespace 'string' is not offline

1 Answers  


RMAN-06750: SPFILE cannot be backed up by proxy.

1 Answers  


LPX-00690: Invalid argument.

1 Answers  


ORA-22918: specified column or attribute is not a VARRAY type

1 Answers  


ORA-27208: syntax error in device PARMS - environment variable value missing

1 Answers  


ORA-23351: parameter datatype string for procedure string not supported

1 Answers  


ORA-13373: element of type extent is not supported for geodetic data

1 Answers  


Categories