使用copy命令拷贝数据表

最新推荐文章于 2023-06-17 23:12:06 发布

weixin_30364147

最新推荐文章于 2023-06-17 23:12:06 发布

阅读量185

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/liaomin416100569/p/9331274.html

版权

实现同一个数据库不同用户间的表的拷贝

首先看下copy命令的解释

SQL> help copy;

COPY
----

Copies data from a query to a table in the same or another
database. COPY supports CHAR, DATE, LONG, NUMBER and VARCHAR2.

COPY {FROM database | TO database | FROM database TO database}
{APPEND|CREATE|INSERT|REPLACE} destination_table
[(column, column, column, ...)] USING query

where database has the following syntax:
username[/password]@connect_identifier

首先给两个不同的用户授予表空间无限制操作权限

grant ulimited tablespace to test1;

grant ulimited tablespace to test;

SQL> copy from test1/test1@orcl1 to test/test@orcl1 create goods using select * from goods;

Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)
Table GOODS created.

16 rows selected from test1@orcl1.
16 rows inserted into GOODS.
16 rows committed into GOODS at test@orcl1.

转载于:https://www.cnblogs.com/liaomin416100569/p/9331274.html