|
-
 Originally Posted by pankajdhingra
My Task is to upgrade the db from version1 to version 2 while project is running.
I am totally confused in it ..
This is not a good idea. It is advisable that you take some down time to perform the upgrade.
When you update your tables to include new columns, the alter table command will acquire an exclusive DDL lock on the object. This will invalidate all of the parsed PL/SQL SQL cursors in the shared pool.
When you create new packages they will acquire a share DDL lock.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote