Sofa Bed,Double Sofa Cum Beds,Sleeping Sectional Beds Sofa,Foldable Single Sleeper Bunk Sofa AU-PINY FURNITURE CO., LTD , https://www.jmaupiny.com
EXECUTE DBMS-REPCAT-ADMIN. GRANT-ADMIN-ANY-SCHEMA(username=>`REPADMIN`);
Grant execute any procedure to REPADMIN;
After setting the site as the primary site, exit and log in again as the replication administrator.
c. Define a snapshot site and establish a link: Log in to systems with ors.
Create user"SNAPADMIN"identified by "SNAPADMIN"
EXECUTE DBMS-REPCAT-ADMIN. GRANT-ADMIN-ANY-SCHEMA(username=>'SNAPADMIN');
Grant alter session to "FWadmin";
Grant Create any snapshot to "FWadmin"
Grant alter any snapshot to "FWadmin"
Creat public database link webdb. Jj.com. Cn using'web-db';;
d. Define source group objects on the main definition site: Log in as repadmin on the webdb database.
EXECUTE DBMS-REPCAT. CREATE-MASFER-REPGROUP(gname=>'"TO-WEBdb"');
EXECUTE DBMS-REPCAT. CREATE-MASTER-REPOB-JECT (gname=>'"TO-WEBdb"',
Type:>'TABLE',oname;>'"iden"',sname=>'"FWadmin"',
Copy-rows=>TRUE, use-existing-object=>TRUE);
EXECUTE DBMS-REPCAT. GENERATE-REPLICATION-StWPORT('FWadmin','iden','table');;
e. Defining the snapshot data on the snapshot site: Log on to CREATE SNAPSHOT Fwadmin as Fwadmin on the on database. Iden RE-FRESH COMHEIE
AS selec* from Fwadmin. Iden@WEBdb. JJ. COM. CN;
f. Copy the data test: connect to the webdb database, the source group table FWadmin. Iden add, delete records or update the data in the table; then connect to the ors database, query FWadmin. The data of the iden table is reflected in the snapshot and the data is copied successfully.
4 Conclusion The article introduced the oracle snapshot replication technology in the digital security system. Remote table replication is more reliable using snapshots. Snapshots can be automatically updated without being affected by network failures. No programming and maintenance are required. Source table updates are not affected by snapshots, and shared data can be accessed more quickly. A simple snapshot can only update the changed records.
With the development of network technologies, data replication is becoming more and more important, and the content of replication is becoming more and more abundant. However, the basic principles are the same. Therefore, a detailed analysis of requirements should be made before copying, for copying sites, copying objects, The type of replication, replication process, etc., are well planned for better application.
Application of Oracle Data Replication Technology in Packaging Enterprises (Part 2)
b. Define the main site: Login to webdb with system create user re·padmin identified by rep default tablespace users temporary ta-blespace temp;