create database link

create database link 文も、毎回調べているのでメモ。。。

using句ベタ書きのパターン

grant dba to a identified by a;
conn a/a
create table test1 ( id number primary key, col1 varchar2(1000));
create database link loopback connect to g identified by g using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=999.999.999.999)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=db1)))';
create materialized view mvtest1 as select * from test1@loopback;