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