&<img src="../resources/images/opentocr.png" title="Open Contents list" border="0"&>
You are here:
Oracle
Building a Table with Create RRNO Column selected
For Oracle, in addition to having permission to alter the table, you require permission to create a sequence and a trigger as the table owner.
Removing X_UPID and X_RRNO Columns
For Oracle, if you remove the columns, you should also remove the trigger and the sequence. Use the Oracle data dictionary views DBA_TRIGGERS and DBA_SEQUENCES (or USER_TRIGGERS and USER_SEQUENCES when you are logged on as the table owner) to find the trigger and sequence to be dropped. (The object names will contain the LANSA table name.)
Also See
Create RRNO Column
&<img src="../resources/images/opentoc-dark.png" title="Open Contents List" border="0"&>