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-14609: Tablespace was not specified for the previous lob segments of column string in template but is specified for string

1 Answers  


ORA-27024: skgfqsbi: sbtinit2 returned error

1 Answers  


ORA-07634: smsdbp: $CRETVA failure

1 Answers  


ORA-18001: no options specified for ALTER OUTLINE

1 Answers  


ORA-30553: The function is not deterministic

1 Answers  






ORA-12091: cannot online redefine table "string"."string" with materialized views

1 Answers  


ORA-22318: input type is not an array type

1 Answers  


ORA-19809: limit exceeded for recovery files

1 Answers  


ORA-14025: PARTITION may not be specified for a materialized view or a materialized view log

1 Answers  


TNS-01190: The user is not authorized to execute the requested listener command

1 Answers  


TNS-12658: ANO service required but TNS version is incompatible

1 Answers  


LFI-01005: Unable to fill buffer.

1 Answers  


Categories