Oracle Database permits DDL operations on a table only if the table can be locked
during the operation. Such table locks are not required during DML operations.
Note: Table locks are not acquired on temporary tables.
ENABLE TABLE
LOCK Specify ENABLE TABLE LOCK to enable table locks, thereby
allowing DDL operations on the table. All currently executing transactions must
commit or roll back before Oracle Database enables the table lock.
Caution: Oracle Database waits until active DML transactions in the
database have completed before locking the table. Sometimes the
resulting delay is considerable.
DISABLE TABLE LOCK
Specify DISABLE TABLE LOCK to disable table locks, thereby
preventing DDL operations on the table.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-1002050/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002850
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
