oracle中使用copy远程创建表
程序员文章站
2022-07-07 21:09:44
...
把本地表localTable复制到远程(192.168.1.11)库上,远程表名称为remoteTable
copy FROM gzmh/gzmh@orcl to testDB/testDB@192.168.1.111:1521/orcl create remoteTable using SELECT * from localTable
copy FROM gzmh/gzmh@orcl to testDB/testDB@192.168.1.111:1521/orcl create remoteTable using SELECT * from localTable