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);