Oracle Replication FAQ
$Date: 27-Nov-1999 $
$Revision: 1.12 $
$Author: Frank Naudé $
Topics
Back to Oracle FAQ Index
Can sequences be replicated?
No, the best way to handle sequences, assuming you are using them as primary
key values, is to concatenate then with something unique to the site.
For example, use a sequence number concatenated with the database name,
site name or something similar. One could also start the sequences at one
site as odd numbers (1, 3, 5, etc) and the other site as even numbers
(2, 4, 6 etc).
Back to top of file
I get "NO DATA FOUND" errors. How does one handle this?
If the application is updating primary key values, you will get lots of
"NO DATA FOUND" errors. Primary keys should NEVER be updated. If you do
update primary keys, conflict resolution becomes extremely difficult.
Back to top of file
How does one delete all local def errors?
From sqlplus say:
SQL> spool delete_errors.sql
SQL> select 'exec dbms_defer_sys.delete_error(''' || deferred_tran_id ||''','''||
SQL> destination || ''')'
SQL> from deferror;
SQL> spool off
SQL> @delete_errors
Back to top of file
Any replication notes?
- Must have 1 master definition site for each replication group
- Ensure triggers don't fire during replication by testing
DBMS_SNAPSHOT.I_AM_A_REFRESH before executing a trigger body.
- There are 12 conflict resolution methods. None will be enabled by default.
Back to top of file
Where can I get more info about replication?
- Visit the Oracle Replication Special Interest Group
and join their excellent mailing list.
- With Redolog based replication, transactions are replicated even before
they are committed in Oracle? Thought this is not possible?
Visit Quest Software
and look around for information about their SharePlex for Oracle product.
- Ever wondered how Advanced Replication works? Check out how easy it is
with Nico Booyse's replication scripts.
Back to top of file