实现同一个数据库不同用户间的表的拷贝
首先看下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.