Home » RDBMS Server » Server Utilities » Intermediate COMMITS when using the sqlldr or imp utilities (oracle 8i HP-UX)
Intermediate COMMITS when using the sqlldr or imp utilities [message #599842] Tue, 29 October 2013 06:32 Go to next message
9390512774
Messages: 97
Registered: January 2011
Location: hyd
Member
Hi Expects,

I want to load lakhs of records into a table. My problem is when after loading the ΒΌ of records my process is abend due to the size of my rollback segment area. I don't have an option to increase it. So, Is there any way to go for intermediate commits when I am using the imp or sqlldr utilities to load the entire data without abend?

Thanks in Advance.
Re: Intermediate COMMITS when using the sqlldr or imp utilities [message #599844 is a reply to message #599842] Tue, 29 October 2013 06:37 Go to previous messageGo to next message
Michel Cadot
Messages: 59505
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Have a look at "commit" parameter of imp and "direct" for SQL*Loader.

Re: Intermediate COMMITS when using the sqlldr or imp utilities [message #599884 is a reply to message #599844] Tue, 29 October 2013 16:46 Go to previous message
Barbara Boehmer
Messages: 7997
Registered: November 2002
Location: California, USA
Senior Member
Also check the size of bindsize and readsize for SQL*Loader.
Previous Topic: Run Exp utility in background mode
Next Topic: import data in one tablespace
Goto Forum:
  


Current Time: Fri Oct 31 09:33:34 CDT 2014

Total time taken to generate the page: 0.10305 seconds