Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-39095: Dump file space has been exhausted: Unable to allocate string bytes

1 Answers  


ORA-14323: cannot add partition when DEFAULT partition exists

1 Answers  


ORA-16606: unable to find property "string"

1 Answers  


ORA-23315: repcatlog version or request string is not supported by version string

1 Answers  


ORA-00369: Current log of thread string not useable and other log being cleared

1 Answers  






LRM-00109: could not open parameter file 'string'

1 Answers  


ORA-14406: updated partition key is beyond highest legal partition key

1 Answers  


ORA-23325: parameter type is not string

1 Answers  


ORA-29862: cannot specify FORCE option for dropping non-domain index

1 Answers  


ORA-01272: REUSE only allowed when a file name is provided.

1 Answers  


ORA-01596: cannot specify system in string parameter

1 Answers  


RMAN-08543: channel string: specifying archivelog(s) for proxy backup

1 Answers  






Categories