Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how does ora-14121 occur ?

LonionApr 14 2013 — edited Apr 15 2013
SQL> ho oerr ora 14121
14121, 00000, "MODIFY DEFAULT ATTRIBUTES may not be combined with other operations"
// *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
Can somebody simulate ora-14121 for me ? i don't know how does it occur ?

Thank you advance .
This post has been answered by Girish Sharma on Apr 15 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 13 2013
Added on Apr 14 2013
1 comment
402 views