导库涉及到语句

Oracle创建directory

create or replace directory dump_dir as 'D:\dump\dir'
这样把目录d:\dump\dir设置成dump_dir代表的directory

2、查询有哪些directory
select * from dba_directories

3、赋权
grant read,write on directory dump_dir to user01

4、删除
drop directory dump_dir

Oracle创建dblink

create public database link link名称
connect to 账号 identified by "密码"
using
'(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =ip地址)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = 实例名称))
)';