DB Wiki

User Tools

Site Tools

Trace:
sequenceother

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
sequenceother [2016/09/30 14:15] – z0hpvksequenceother [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 1: Line 1:
 +==== PL/SQL for Other Objects ====
 +Below is the code required in order to create ...
 +  * Database Links
 +  * Tables
 +  * Scheduled Jobs
 +... for sequences in a bi-directional format. 
 +
 <code>-- Create on 10g Database <code>-- Create on 10g Database
-Create public database link ggint+Create public database link ggmolbb
 connect to ggate identified by ggate123 connect to ggate identified by ggate123
-using ‘molintpc’;+using 'molintpc';
  
 -- Create on 12c Database -- Create on 12c Database
-Create public database link ggpoc+Create public database link ggandraca
 connect to ggate identified by ggate123 connect to ggate identified by ggate123
-using ‘molinta’;+using 'molinta';
  
 Create table sync_sequences_log (owner varchar2(20), sequence_name varchar(50),  Create table sync_sequences_log (owner varchar2(20), sequence_name varchar(50), 
Line 16: Line 23:
                                valuint number(12), valuepoc number(12));                                valuint number(12), valuepoc number(12));
  
--- Example Scheduled Job that runs every half hour to keep sequence values in sync.  +-- Example Scheduled Job that runs every hour to keep sequence values in sync.  
 BEGIN BEGIN
 DBMS_SCHEDULER.create_job ( DBMS_SCHEDULER.create_job (
sequenceother.1475244955.txt.gz · Last modified: 2025/03/08 22:23 (external edit)