RDBPROD: Locking When Creating/Dropping Index On Table
(Doc ID 390562.1)
Last updated on MARCH 04, 2020
Applies to:Oracle Rdb Server on OpenVMS - Version 7.0 and later
HP OpenVMS VAX
HP OpenVMS Alpha
HP OpenVMS Itanium
When trying to create or drop an index on a table which has been used by other users who remain connected to the database, the CREATE/DROP INDEX waits until these users have all disconnected. Why?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document