Oracle database link connects databases to replicate data

--1. Create a Dblink connection

Create DATABASE link mdm66 connect to lc019999 identified by aaaaaa using ' 10.24.12.66/ORCL '; --mdm66 for the connection name, you can name it, lc019999 to access the database user name, aaaaaa for the password, 10.24.12.66/ORCL the IP address and service name of the database

--2. Query data select * FROM [email protected]--the queried field cannot contain CLOB and blob type--3. Copy table data CREATE TABLE Mdmwldw_bak as SELECT * from [email protected]--4. Query all Dblinkselect * from Dba_db_links--5. Delete dblinkdrop public database link dblinkname;

Oracle database link connects databases to replicate data