SetUp Destination database
1. Create a dedicated database user at destination database for Helyx replication activities.
CREATE USER helyx IDENTIFIED BY <password>;Note
The password for helyx user at source and destination database must be same.
2. Grant Required Privileges
Grant the following privileges to the helyx user :
GRANT CONNECT, RESOURCE TO helyx;ALTER USER helyx QUOTA UNLIMITED ON USERS;GRANT UNLIMITED TABLESPACE TO helyx;Note
By default, Helyx creates objects in the USERS tablespace.
If a different tablespace is required, create helyx user as shown below.
CREATE USER helyx IDENTIFIED BY <password> DEFAULT TABLESPACE tblspc_helyx QUOTA UNLIMITED ON tblspc_helyx;3. Provide necessary privileges to helyx user at destination database
GRANT SELECT ANY TABLE TO HELYX;GRANT INSERT ANY TABLE TO HELYX;GRANT UPDATE ANY TABLE TO HELYX;GRANT DELETE ANY TABLE TO HELYX;GRANT CREATE ANY TABLE TO HELYX;GRANT ALTER ANY TABLE TO HELYX;GRANT CREATE ANY INDEX TO HELYX; GRANT CREATE ANY TRIGGER TO HELYX;