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

ORA-28113: policy predicate has error

1 Answers  


ORA-19910: can not change recovery target incarnation in controlfile

1 Answers  


TNS-00121: Missing CMANAGER_NAME in INTCHG.ORA

1 Answers  


ORA-13914: Threshold notification failed.

1 Answers  


RMAN-03014: implicit resync of recovery catalog failed

1 Answers  






ORA-16137: No terminal recovery is required

1 Answers  


ORA-06118: NETTCP: unable to complete handshake with ORASRV

1 Answers  


ORA-06312: IPA: Incorrect outgoing service name supplied

1 Answers  


NID-00145: nls subsystem initialization failure for product=string, facility=string

1 Answers  


ORA-01409: NOSORT option may not be used; rows are not in ascending order

1 Answers  


TNS-04015: Current instance string is not yet started

1 Answers  


LPX-00317: undefined decimal-format "~S"

1 Answers  


Categories