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 to add deferrable initially deferred option to existing primary key ...

998099Mar 21 2013 — edited Mar 21 2013
see this example...
create table delete_me(id number constraint pk_id1 primary key);


i have to add deferrable initially deferred keyword to existing created constraint...i tried...but this gives me error..
alter table delete_me1 modify pk_id1 deferrable initially deferred;

invalid ALTER TABLE option
01735. 00000 - "invalid ALTER TABLE option"
*Cause:
*Action:
how to solve it..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2013
Added on Mar 21 2013
3 comments
4,514 views