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

TNS-00205: Turning off tracing in intlsnr

1 Answers  


ORA-16639: specified instance inactive or currently unavailable

1 Answers  


ORA-12063: unable to apply transaction from site string

1 Answers  


ORA-30455: summary contains VARIANCE without corresponding SUM & COUNT

1 Answers  


NID-00602: Could not allocate number bytes for "string"

1 Answers  






ORA-02027: multi-row UPDATE of LONG column is not supported

1 Answers  


NNO-00152: warning: hint count number exceeds maximum of number, first number will be loaded

1 Answers  


ORA-10563: Test recovery had to corrupt data block (file# string, block# string) in order to proceed

1 Answers  


ORA-16178: Cannot specify remote destinations in archivelog manual mode

1 Answers  


ORA-29305: cannot point-in-time recover tablespace 'string'

1 Answers  


ORA-27057: cannot perform async I/O to file

1 Answers  


NZE-28819: No distinguished name provided.

1 Answers  


Categories