rs_locks
The following table lists the columns for the rs_locks view. The equivalent jcs_locks view is available for backward compatibility reasons. The difference between the two is the data type of the date/time columns; the rs_* views use TIMESTAMP WITH TIME ZONE while the jcs_* views use DATE.
Column | Datatype | Description |
ID | NUMBER | The unique id of a lock |
PARTITION | VARCHAR2 | The unique partition of a lock |
NAME | VARCHAR2 | The unique name of a lock |
VERSION | NUMBER | The version number of a lock |
DESCRIPTION | VARCHAR2 | The description of a lock |
APPLICATION_PARTITION | VARCHAR2 | The partition of the application; can be used to group Redwood objects in logical groups |
APPLICATION_NAME | VARCHAR2 | The name of the application; can be used to group Redwood objects in logical groups |
LOCKED_BY_JOB_ID | NUMBER | Current owner of the lock |
COMMENT_TEXT | VARCHAR2 | Comment describing the lock |
note
VERSION: Version is not increased with one anymore after changing the object.
plsqlTopic
onsiteTopic