将远程数据库中的某表数据复制到本数据库(ORACLE)

1. 建立 DATABASE LINK
CREATE PUBLIC DATABASE LINK ABC
CONNECT TO SA IDENTIFIED BY PASSWORD
USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = AAA)))';

2、建立表
CREATE TABLE LOCAL_TABLE  SELEC * FROM  TABLE@ABC;