Sequence object types cannot be replicated - Oracle Replication

Q.  Which of the following object types cannot be replicated?

- Published on 12 Aug 15

a. Data
b. Trigger
c. View
d. Sequence

ANSWER: Sequence
 

    Discussion

  • Nirja Shah   -Posted on 18 Sep 15
    - The following objects can be replicated:
    1. Data (obviously)
    2. Triggers, views, indexes, synonyms, etc. (with advanced replication)

    - The following objects cannot be replicated
    1. Sequences (Sequences needs to be created on each site to generate mutually exclusive sets of sequence numbers).
    2. LONG and LONG RAW data types (Use LOBs instead)

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)