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
> replicating the table in oracle database, Need to replicate table in oracle database
saicharan
post Mar 3 2017, 12:55 AM
Post #1


Newbie
*

Group: Members
Posts: 1
Joined: 3-March 17
Member No.: 51,815



Hi Team,

In oracle database I have a table say xyz, and I want to have a replica of that table as xyz_replica in same database and same schema. so that when ever there is DML operation such as delete,insert,update statements runs on the xyz table is has to replicate in xyz_replica table.

I thought of using triggers but not sure how to write the query when doing the update or delete as I am unsure how many rows will get changed in xyz table.


Thanks in advance.
Saicharan
Go to the top of the page
 
+Quote Post
burleson
post Mar 10 2017, 12:21 PM
Post #2


Advanced Member
***

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



Hi Saicharan and welcome to the forum!

>> In oracle database I have a table say xyz, and I want to have a replica of that table as xyz_replica in same database and same schema.

You want to replicate a single table using snapshot replication:

http://www.dba-oracle.com/data_warehouse/t...replication.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: 25th July 2017 - 07:44 AM