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

ORA-31419: source table string does not exist

1 Answers  


ORA-15045: ASM file name 'string' is not in reference form

1 Answers  


PCC-02317: illegal cast type expression

1 Answers  


RMAN-02003: unrecognized character: string

1 Answers  


NNO-00058: cannot load topology data from configuration database

1 Answers  






ORA-09985: SGA definition file could not be read

1 Answers  


ORA-19569: no device is allocated to this session

1 Answers  


PLS-00646: MAP or ORDER method must be defined in the root of the subtype hierarchy

1 Answers  


ORA-12591: TNS:event signal failure

1 Answers  


ORA-30176: invalid format code used in the format string

1 Answers  


NZE-28838: no identity descriptor

1 Answers  


ORA-01273: STANDBY_FILE_MANAGEMENT = AUTO needs COMPATIBLE = string or higher

1 Answers  


Categories