-
bulk insert
i want to insert a bulk files containing more than 2.5 million row but if I do and import I will face snapshot too old so I plan to break the files to smaller file......can anyone tell me what is the fatest way to insert bulk datas without facing this error.
-
use direct-insert
insert /*+ APPEND */ select * from x
-
posibly with PARALLEL opt.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
As suggested by other members (PARALLEL, HINT /*+APPEND ), you can also disable logging for the object(s). Ofcourse in order to get rid of snapshot 2 old error
set transaction to
-
set transaction to "bigRollbackSegment"
-
Syntax
------
SET TRANSACTION USE ROLLBACK SEGMENT RB_large
-
I have tried using that method of insert with big rollback but I still hit with an error of snapwhot too old....Just to enquire if I can break the import to smaller files
-
Yes u can break the export file by using QUERY clause if it's just a matter of one table based on the primary key or any other criteria.
HTH
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
|