Oracle 11g R2 I have three interval partition tables that I will be updating two or three partitions in each every night using exchange partition. I need to lock the users from reading these tables during the exchange process. Lock table is release on a rollback or commit. Does the data dictionary update for the exchange partition issue a commit that will release the lock? I would test this out but I don't have a database where I have the privileges to do an exchange partition step, yet.
Thanks in advance.