Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> How to tell the corresponded extract for replicat, How to tell the corresponded extract for replicat
Iuliana
post Apr 14 2017, 07:20 AM
Post #1


Newbie
*

Group: Members
Posts: 2
Joined: 30-July 13
Member No.: 48,820



Hello,
i am new in golden gate.
I would like to find a way of
how to tell the corresponded extract for replicat ( can this be done trough sql by using golden gate views?
If yes what are those ) , or what are the commands .
Thanks in advance for help.
Go to the top of the page
 
+Quote Post
burleson
post Apr 25 2017, 10:18 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,437
Joined: 26-January 04
Member No.: 13



Hi Iuliana, and welcome to the forum!

>>how to tell the corresponded extract for replicat ( can this be done trough sql by using golden gate views?)

Create Target Mapping




Select the Map icon for the Delivery. The list of candidate tables from the Capture mapping is displayed. The next step is to manually create the table mapping using:

Enter the Target table. Use the format <Schema.Tablename>.

Click on "Add Blank Mapping", the plus sign (+), when the extract uses a wildcard for table names.

Check candidate tables.

Click "Save."

This may help:

http://www.dba-oracle.com/t_goldengate_deploy.htm




--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd June 2017 - 05:25 AM