ORA-14175: a subpartition maintenance operation may not be
combined with other operations



ORA-14175: a subpartition maintenance operation may not be combined with other operations..

Answer / guest

Cause: ALTER TABLE or ALTER INDEX statement attempted to
combine a subpartition maintenance operation (e.g. MOVE
SUBPARTITION) with some other operation (e.g. MODIFY
PARTITION ADD SUBPARTITION or PCTFREE) which is illegal

Action: Ensure that a subpartition maintenance operation is
the sole operation specified in ALTER TABLE or ALTER INDEX
statement; operations other than those dealing with
subpartitions, default attributes of partitioned
tables/indices or specifying that a table be renamed (ALTER
TABLE RENAME) may be combined at will

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07476: slsget: cannot get mapped memory statistics.

1 Answers  


PLS-00169: modifier 'string' conflicts with prior 'string' specification

1 Answers  


NZE-29033: Invalid PFX

1 Answers  


SQL*Loader-00462: error inserting LOB into column string, row number, table string

1 Answers  


ORA-32575: Explicit column default is not supported for modifying views

1 Answers  






PLS-00161: Pragma string expects 3rd argument to be an identifier or a string literal

1 Answers  


PLS-00582: attribute declarations are not allowed in opaque types

1 Answers  


ORA-19756: corrupt block number string found in change tracking file

1 Answers   Scope International,


QSM-02137: agg(expr) requires correspondng STDDEV(expr) function

1 Answers  


ORA-16625: cannot reach the primary

1 Answers  


NNL-00933: Requests refused, OTHER-DATA violation: number

1 Answers  


TNS-01162: Syntax error in the address resolved from the spawn alias: string

1 Answers  


Categories