ORA-14121: MODIFY DEFAULT ATTRIBUTES may not be combined
with other operations



ORA-14121: MODIFY DEFAULT ATTRIBUTES may not be combined with other operations..

Answer / guest

Cause: ALTER TABLE or ALTER INDEX statement attempted to
combine MODIFY DEFAULT ATTRIBUTES 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

PCC-02387: Expecting an expression of type sql_cursor

1 Answers  


ORA-22871: ALTER TYPE with REPLACE is not allowed for pure incomplete types

1 Answers  


ORA-31602: parameter string value "string" in function string inconsistent with string

1 Answers  


ORA-12487: clearance labels not between DBHIGH and DBLOW

1 Answers  


ORA-15124: ASM file name 'string' contains an invalid alias name

1 Answers  






ORA-38432: EVALUATE operator only allowed on an expression column

1 Answers  


IMG-00805: SIGNATURE data has been corrupted or is invalid

1 Answers  


ORA-07848: sllfrb: $GET failure

1 Answers  


ORA-07262: sptpa: sptpa called with invalid process id.

1 Answers  


ORA-16768: Logical apply service unexpectedly offline

1 Answers  


ORA-12820: invalid value for DEGREE

1 Answers  


ORA-10589: Test recovery had to corrupt string data blocks in order to proceed

1 Answers  


Categories