I need to know exactly when the tables are closed after unloading the servers.
The tables are updated the data in the following way:
Indexes are added some to a copy of the table.
Some data massaging is done to a copy of the table.
The servers are unloaded.
The old tables are deleted and the table copies are renamed as the old tables.
The servers are brought back up.
I know there are other ways to handle this, but budget constraints prevents us from looking at other avenues at this time.

How can we know with certainty that all tables have been released so that can be opened exclusively, if need be.

TIA