LOCK TABLE Statement

Manually lock one or more tables.

Syntax:

   LOCK TABLE [schema.] table [options] IN lockmode MODE [NOWAIT]

   LOCK TABLE [schema.] view [options] IN lockmode MODE [NOWAIT]

options:
      PARTITION partition
      SUBPARTITION subpartition
      @dblink

lockmodes:
      EXCLUSIVE
      SHARE
      ROW EXCLUSIVE
      SHARE ROW EXCLUSIVE
      ROW SHARE* | SHARE UPDATE*

If NOWAIT is omitted Oracle will wait until the table is available.

EXCLUSIVE = Allow queries only
SHARE = Allow concurrent queries but not UPDATE

ROW EXCLUSIVE locks are automatically granted for DELETE, UPDATE, INSERTs

* = Oracle 6 option included for compatibility

Related Commands:

COMMIT
DELETE
INSERT
ROLLBACK
SELECT
UPDATE
DBMS_LOCK

Related Views:

  DBA_ALL_TABLES       ALL_ALL_TABLES       USER_ALL_TABLES
  DBA_TABLES           ALL_TABLES           USER_TABLES         TAB
                                                                DICTIONARY
                                                                DICT_COLUMNS
  V$LOCK
  V$_LOCK
  V$LOCKED_OBJECT
  V$LOCKS_WITH_COLLISIONS
  V$LOCK_ACTIVITY
  V$LOCK_ELEMENT