||Oracle Replication Tips by Burleson
Define the Oracle replication Conflict
add an additional column to the sales table that we’ll call
of type DATE.
sname => '"PUBS"',
oname => '"SALES"',
type => 'TABLE',
ddl_text => -
'alter table PUBS.SALES add (SALES_TS DATE)');
Now that we have added our column, we want it populated each time
some action takes place on the table. To perform this action we
write the following database trigger:
create trigger SALES_TS_TG
before insert or update
for each row
if dbms_reputil.from_remote = FALSE
then :NEW.SALES_TS := SYSDATE;
This is an
excerpt from Oracle Replication By Rampant TechPress (only $19.95).
You can click here to order a copy and get instant access to the code
Get a Personal Oracle
The author is now offering personal mentors for
Oracle DBAs where you can have an Oracle expert right at your
fingertips, anytime day or night. We work with hundreds of Oracle
databases every year, so we know exactly how to quickly assist you
with any Oracle replication question.
You can get me personally, or any Oracle Certified replication DBA
with more than 20 years of full-time IT experience.