How to reset/rebuild sequences?
Hi,
I am going to configure bi-direction DML replication. For sync-up the soure and target DB, I am planing to use initial data load (using direct load). But I am confused, Should I need to do reset/rebuild the sequences also ?
if yes, then how can I achieve this?
Please share the steps which I should follow to achieve the bi-direction replication.
currentally I am following these steps (there is no sequence setup here), Please suggest if anything wrong here.
Downloading the software from the Oracle Website.
Unpacking the installation zip file.
Preparing the source and target systems.
Installing the software on source and target systems.
Preparing the source database.
Configuring the Manager process on the source and target systems.
Configuring the Extract process on the source and target system.
Configuring the Data Pump process on the source and target system.
Configuring the Replicat process on the source and target system.
Starting the Extract process on the source and target system.
Starting the Data Pump process on the source and target system.
Performing the Initial Data Load using Direct Load
Starting the Replicat process on the source and target system.
Thanks