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!

LOCK Table from DML operations

PS SPJul 8 2022

Hi Experts,
I have a requrement, want my table to lock until some operations with in table creations are done. (Ex : altering fields, data types etc.. thru an automation). During the table creation in case of any failures occurs, table should be in locked from all DML operation for all users.
Thanks

Comments

Post Details

Added on Jul 8 2022
8 comments
590 views