Wednesday, September 23, 2015

Table copy command in Oracle

set arraysize 5000
set copycommit 20

copy from user/password@dbname1.world -
to user/password@dbname2.world -
insert table_name  -
using select * from schema.table_name

No comments: