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!

creating primary key in online?

754491Aug 24 2010 — edited Aug 24 2010
My database is oracle11g. My environment is 24*7.

I know we can create index online. But here this is primary key. I need to do below things.. These task should not lock the table.

1. drop the Primary key
2. recreate the primary key
3. drop the normal index
4. recreate the normal index.

Task 4 can be done in online. I am concerned the rest of the task.

1. Does oracle lock the table while dropping the PK?
2. How do i recreate the PK online?
3. Does oracle lock the table while dropping the index?

Please let me know.
This post has been answered by 618702 on Aug 24 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2010
Added on Aug 24 2010
5 comments
1,006 views