电信运营商Oracle备份

Oracle数据库中如何将一个备份库中的一个表导入到现有的库中?

参与8

1同行回答

lscomeonlscomeon  其它 , 收割者
create / public / database link dblinkname  connect to dbusername identified by dbpassword   using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 备份库IP)(PORT = 备份库port)))(CONNECT_DATA =(SERVICE_NAME = 备份库name)))'; do s...显示全部

create / public / database link dblinkname
  connect to dbusername identified by dbpassword
  using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 备份库IP)(PORT = 备份库port)))(CONNECT_DATA =(SERVICE_NAME = 备份库name)))';

do something from 表@dblinkname

//create table xxx as select * from 表@dblinkname

收起
国防军队 · 2017-12-04
浏览1310

相关问题

相关资料

相关文章

问题状态

  • 发布时间:2017-12-04
  • 关注会员:2 人
  • 问题浏览:1521
  • 最近回答:2017-12-04
  • X社区推广