Database Error Messages

OCI-43547

Cannot create or alter notification directive 'string': column name 'string' conflicts with a column name reserved for use by the notification table

Cause

An attempt is being made to create or alter a notification directive that logs one or more columns with names that are reserved for use by the notification table.


Action

Do not specify a base table with the following reserved column names: USN, SLOT, SQN, OPCODE, CLIENT_INFO, ACTION, CURRENT_USER, BASE_TABLE_ROWID, XCN, or COMMIT_SCN.

Alternatively, create or modify the LOGGED COLUMNS clause to exclude the offending columns.