Bhakt's World
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
Blog Archive
April (1)
July (3)
October (1)
September (4)
January (1)
About Me
Chirag Patel
View my complete profile
No comments:
Post a Comment