Creating a maintenance user for replication

The maintenance user is a valid Oracle user that the Replication Server uses to apply commands to the replicate Oracle database. Replication Server requires one maintenance user to be defined for each connection. Do not use the same name as the DCO Admin Account Name used in configuring the DirectConnect server.

1. Use SQLPLUS to connect to the replicate database, and enter:

   create user maintuser identified by password;
   

2. Grant dba and create session permissions to the maintenance user, who must have permission to issue SQL commands against any table to be replicated:

   grant dba to maintuser;
   

   grant create session to maintuser;
   

   exit SQLPLUS;