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

CLSS-03200: timed out waiting on nested reconfiguration

1 Answers  


ORA-00279: change string generated at string needed for thread string

1 Answers  


TNS-12227: TNS:syntax error

1 Answers  


TNS-01050: %s

1 Answers  


ORA-37083: Invalid object string

1 Answers  






LFI-01007: Line is too long; encountered in function string.

1 Answers  


ORA-24368: OCI mutex counter non-zero when freeing a handle

1 Answers  


ORA-25255: incorrect subscription string string

1 Answers  


DRG-11728: phrase does not have any broader terms of this type

1 Answers  


ORA-36635: (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition.

1 Answers  


ORA-14069: invalid TABLESPACE_NUMBER value

1 Answers  


TNS-12599: TNS:cryptographic checksum mismatch

1 Answers  


Categories