Im using liquibase to run multiple scripts. SQL Scrpt 1 : alter table script for Customers SQL script 2: insert into customers.
Script 1 fails bc script 2 is trying to run while the table is being altered.
( ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired)
Is there a way to ensure the previous script( script 1) is committed before script 2 starts?
Do I need to add a wait before script 2? that doesn't seem optimal I couldn't find anything to address this.
Thank you!
