Lock Table

	A	B	C	D	E	F	G	H

Allowed: Prohibited: Other Notes: ROW SHARE (SHARE UPDATE*) ROW EXCLUSIVE SHARE SHARE ROW EXCLUSIVE EXCLUSIVE Concurrent access Locking for exclusive access Yes Yes - - - Locking in SHARE mode Automatically obtained for DML - Yes - - - Concurrent queries Updates - - Yes - - Others to look at rows Others from locking w/SHARE. Updating rows Used to look at a whole table - - - Yes - Queries Anything else - - - - Yes * kept for backward compatilibity

• Some locks can be placed at the same time. Other locks allow only one. (??)
• Remains locked until you commit or rollback.
• Never prevents queries
• 'View' locks the base tables of the view.
• If view is part of a hierarchy, then it must be the root.

The table or view

1. must be in your own schema or
2. you have LOCK ANY TABLE or
3. you have any object privilege on the table or view.

LOCK TABLE
[ schema. ] { table | view } [ { PARTITION (partition) | SUBPARTITION (subpartition) } | @ dblink ] [,
[ schema. ] { table | view } [ { PARTITION (partition) | SUBPARTITION (subpartition) } | @ dblink ] ]...
IN lockmode MODE
[ NOWAIT ] ;

If you specify [SUB]PARTITION, then an implicit lock of the same type is first acquired on the table except for:

• SHARE: acquires an implicit ROW SHARE lock on the table.
• EXCLUSIVE: acquires an implicit ROW EXCLUSIVE lock on the table.

dblink - only if distributed functionality(??). All must be on the same database.

NOWAIT a message returns if other locks. Otherwise, waits until table available, locks it before returning control.