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-22926: specified trim length is greater than current LOB value's length

1 Answers  


PCC-00146: Illegal value for host option, ignored

1 Answers  


ORA-14324: values being added already exist in DEFAULT partition

1 Answers  


DRG-10314: logging has not been started

1 Answers  


TNS-12620: TNS:requested characteristic not available

1 Answers  


ORA-13383: inconsistent network metadata: string

1 Answers  


ORA-14318: DEFAULT partition must be last partition specified

1 Answers  


TNS-00212: Total Pumps Started : number

1 Answers  


QSM-01601: rollup(s) took place on equivalence, string

1 Answers  


ORA-28671: UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole

1 Answers  


PLS-00486: select list cannot be enclosed in parentheses

1 Answers  


ORA-31203: DBMS_LDAP: PL/SQL - Init Failed.

1 Answers  


Categories