creating primary key in online?
754491Aug 24 2010 — edited Aug 24 2010My 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.