|
-
 Use SQL*Plus COPY
Dude,
Look no further.
Use the SQL*Plus COPY command it works great copying big data.
be sure to set the following 2 var's in SQL*Plus as they directly affect how many rows to copy before commiting. You will not have to worry about big RB's or anything. This is way you should do it.
set arraysize
set copycommit
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote