Skip to Main Content

SQL & PL/SQL

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!

Moving object out of Pool

SB35Jul 14 2021

Oracle version 19C. We have a requirement as part of which we want to add few table to KEEP POOL and remove few out of the KEEP POOL(using syntax below). Want to understand if this operation is achievable online without any lock, if DML's are continuously happening on the those base tables? Or is there any other way to achieve that?
alter table mytab storage (buffer_pool keep);
alter table mytab storage (buffer_pool default);

Comments
Post Details
Added on Jul 14 2021
7 comments
566 views