ORA-14165: MODIFY DEFAULT ATTRIBUTES FOR PARTITION may not
be combined with other operations



ORA-14165: MODIFY DEFAULT ATTRIBUTES FOR PARTITION may not be combined with other operations..

Answer / guest

Cause: ALTER TABLE or ALTER INDEX statement attempted to
combine MODIFY DEFAULT ATTRIBUTES OF PARTITION with some
other operation (e.g. ADD PARTITION or PCTFREE) which is illegal

Action: Ensure that MODIFY DEFAULT ATTRIBUTES is the sole
operation specified in ALTER TABLE or ALTER INDEX statement;
operations other than those dealing with partitions, 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

LPX-00103: document structure does not match DTD

1 Answers  


RMAN-06545: "string" is an invalid response - please re-enter.

1 Answers  


TNS-00092: * CMANAGER (or intlsnr) - will ask the Cmanager only

1 Answers  


ORA-00365: the specified log is not the correct next log

1 Answers  


LSX-00104: duplicate type "~S"

1 Answers  


PLS-00140: duplicate external LIBRARY specification in subprogram expression

1 Answers  


ORA-06979: X.25 Driver: server cannot start oracle

1 Answers  


ORA-29253: Invalid count argument passed to procedure dbms_sql.define_array

1 Answers  


PLS-00492: variable or constant initialization may not refer to functions declared in the same package

1 Answers  


RMAN-06432: recovery catalog dropped

1 Answers  


TNS-12213: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA

1 Answers  


RMAN-06532: redundancy count must be greater than zero

1 Answers  


Categories