How Can I copy Oracle data correctly?

The following articles mainly describe Oracle Data Replication and the specific operation steps of Oracle Data Replication in actual operations. The following is a detailed description of the article, hoping to help you in this regard.

Interval: interval. sysdate + 1 indicates the interval of one day, and sysdate + 1/24 indicates the interval of one hour.

Delay_seconds: the delay time for stopping the cleanup operation when there is no delay event in the delayed queue.

4. Create a replication proxy for the materialized view site. Create a copy proxy user and grant the view receiver permissions. The replication proxy is the user who copies the receiver to connect to the main site.

 
 

  
  
disconnect;   
  
  
connect system/passwd@SH;   
  
  
create user proxy_bjOracle identified by proxy_bjOracle;   
  
  
begin   
  
  
dbms_repcat_admin.register_user_repgroup(   
  
  
user_name=>’proxy_bjOracle,   
  
  
privilege_type => ’proxy_snapadmin’,list_of_gnames => NULL);   
  
  
end;   
  
  
/   
  
  
grant select_catalog_role to proxy_bjOracle;  
 
 

5. Create a subject group:

 
 

  
  
disconnect;   
  
  
connect repadmin/repadmin@SH;   
  
  
begin   
  
  
dbms_repcat.create_master_repgroup(gname=>’sh_rep’);   
  
  
end;   
  
  
/  
 
 

6. Oracle Data Replication: Add a copy object to the subject group:

A) add a table:

 
 

  
  
begin   
  
  
dbms_repcat.create_master_repobject(   
  
  
gname=>’sh_rep’,   
  
  
type=>’TABLE’,   
  
  
oname=>’ CREDIT_CARD’   
  
  
sname=>’SHORACL’   
  
  
use_existing_object=>TRUE,   
  
  
copy_rows=>TRUE);   
  
  
end;  
 
 

The above content is an introduction to Oracle Data Replication. I hope you will find some benefits.