Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
Property | Description |
---|---|
Parameter type | Boolean |
Default value | false |
Modifiable | ALTER SESSION , ALTER SYSTEM |
Range of values | true | false |
Basic | No |
DDL_WAIT_FOR_LOCKS
specifies whether DDL statements (such as ALTER TABLE ... ADD COLUMN
) wait and complete instead of timing out if the statement is not able to acquire all required locks.
Values:
true
DDL statements wait until the statement acquires all required locks
false
DDL statements time out if the statement cannot obtain all required locks