Apply Error handling

The Apply process is quite sensitive to errors that may result on account of a variety of situations. The following common types of Apply process errors may be encountered for LCR events:

ORA-01031 Insufficient Privileges
ORA-01403 No Data Found
ORA-23605 Invalid Value for Streams Parameter*
ORA-23607 Invalid Column*
ORA-24031 Invalid Value, parameter_name should be Non-NULL*
ORA-26687 Instantiation SCN Not Set
ORA-26688 Missing Key in LCR*
ORA-26689 Column Type Mismatch*
ORA-01031 Insufficient Privileges

This message is generated when the user designed as the Apply user does not have sufficient privileges to perform DDL or DML activities. The Apply user needs to be given the following privileges:

• For table level DML changes, the INSERT, UPDATE, DELETE, and SELECT privileges must be granted.
   

• For table level DDL changes, the ALTER TABLE privilege must be granted.
   

• For schema level changes, the CREATE ANY TABLE, CREATE ANY INDEX, CREATE ANY PROCEDURE, ALTER ANY TABLE, and ALTER ANY PROCEDURE privileges must be granted.