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-12688: Login failed: the SecurID server rejected the new pincode

1 Answers  


IMG-00822: area queue reset failed

1 Answers  


ORA-22327: cannot change a type to NOT INSTANTIABLE if it has dependent tables

1 Answers  


ORA-01118: cannot add any more database files: limit of string exceeded

1 Answers  


NNL-00549: Displays stream usage statistics

1 Answers  






ORA-16168: LGWR network server could not switch to blocking mode

1 Answers  


RMAN-06400: database opened

1 Answers  


ORA-07208: sfwfb: failed to flush dirty buffers to disk.

1 Answers  


ORA-07717: sksaalo: error allocating memory

1 Answers  


PLS-00989: Cursor Variable in record, object, or collection is not supported by this release

1 Answers  


ORA-27026: skgfrls: sbtend returned error

1 Answers  


ORA-28023: must revoke grants of this role to other user(s) first

1 Answers  


Categories