oracle数据导入-dblink方式

---从生产库导特定时间段的数据到开发库
create database link linkForProdoctorDBToDevDB
connect to fzept identified by neu
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dggtspbarp01-or)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = barpdev)
)
)';

posted @ 2017-03-23 09:55  闲莫等  阅读(426)  评论(0)    收藏  举报