|
-
Please correct me if I am wrong.
You try to insert 800 Million rows. I think the source data are in multiple flat files. Avoid using parallel option if you want unequal extents in a tablespace. Use DIRECT load option with unrecoverable defined in the control file.
You can run multiple direct loads if you do not want to use parallel option.
Set INITIAL and NEXT 500MB size at table level.
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
|