Discussions
Categories
- 385.1K All Categories
- 2.6K Data
- 605 Big Data Appliance
- 2K Data Science
- 452.2K Databases
- 222.4K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 576 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 575 SQLcl
- 4K SQL Developer Data Modeler
- 187.8K SQL & PL/SQL
- 21.5K SQL Developer
- 12 Data Integration
- 12 GoldenGate
- 297.7K Development
- 3 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 294.4K Development Tools
- 118 DevOps
- 3.1K QA/Testing
- 646.5K Java
- 30 Java Learning Subscription
- 37K Database Connectivity
- 185 Java Community Process
- 107 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 174 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 587 LiveLabs
- 41 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 197 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 240 Portuguese
Golden Gate replication in same database
Is it possible to replicate data between two schemas of same Oracle database through golden gate? We are trying to avoid having to query on source schema directly in order not to overwhelm source tables and there is a plan in future to move target schema to a separate database.
Best Answer
-
Yes, this is possible. You can replicat data between two schemas of same database using OGG.
Regards,
Veera
Answers
-
Yes, this is possible. You can replicat data between two schemas of same database using OGG.
Regards,
Veera
-
Hi,
Yes, it is possible.
All you would need to do is in the extract parameter file add
TABLE schema1.* ------> if you want to replicate entire schema
TABLE schema1.table1 ----> If you want to replicate specific table
And at replicat end, add below parameter
MAP schema1.*, TARGET schema2.*; ----> for entire schema
MAP schema1.table1, TARGET schema2.table2;---> for individual table replication
-
Thanks for the quick response