数据库远程连接DATABASE LINK

--欲远程数据库

--查询原表空间的文件路径

select t.*  from sys.dba_data_files t where t.tablespace_name ='SPACE_NAME'


--建表空间
create tablespace space_name_link datafile 'path/wxzjzjk.dbf' size 1024M reuse; 

--建用户 
create user USERNAME
  identified by ""
  default tablespace space_name_link 
  temporary tablespace TEMP
  profile DEFAULT;
-- Grant/Revoke role privileges 
grant dba to USERNAME;
-- Grant/Revoke system privileges 
grant unlimited tablespace to USERNAME;

--当前数据库

--在当前数据库用户下建link

CREATE PUBLIC DATABASE LINK LINK_NAME
CONNECT TO USERNAMEIDENTIFIED BY PASS
USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = ip)(PORT = port)))(CONNECT_DATA =(SERVICE_NAME = dbname)))';


--删掉link
DROP PUBLIC DATABASE LINK LINK_NAME


--查询
select * from table_name@LINK_NAME