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

SQL-02126: Count of array elements cannot be negative (i.e. < 0)

1 Answers  


ORA-28234: key length too short

1 Answers  


ORA-06927: CMX: T_DATAIN received before all data written

1 Answers  


ORA-06440: ssaio: the asynchronous read returned incorrect number of bytes

1 Answers  


TNS-00251: Failure in nstest:

1 Answers  






EXP-00026: conflicting modes specified

4 Answers  


ORA-01128: cannot start online backup - file string is offline

1 Answers  


ORA-32018: parameter cannot be modified in memory on another instance

1 Answers  


ORA-00977: duplicate auditing option

1 Answers  


ORA-09983: skxfidsht: Error shutting down SDI channel

1 Answers  


ORA-38749: A media recovery has been started.

1 Answers  


NNO-00059: cannot construct topology checkpoint file name

1 Answers  


Categories