|
-
thanks , Tamil.
I'll create the indexes after the load.
To do the insert,
I enabled parallel query dml by
alter session enable parallel query dml;
then, I used hints like
INSERT /*+PARALLEL(test_httpaccesslog,4) */ INTO test_httpaccesslog NOLOGGING
(select /*+PARALLEL(x_accesslog,4)*/ *
from x_accesslog);
For a table of 19 million rows( , it took me exactly 20 minutes.
Does it work this way or can it be even faster.
Also,
How do I do parallel load with direct option.
Thanks a lot
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
|