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: 103
Registered: January 2011
Location: hyd
Senior 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.

Report message to a moderator

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: 68767
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

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

Report message to a moderator

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: 9106
Registered: November 2002
Location: California, USA
Senior Member
Also check the size of bindsize and readsize for SQL*Loader.

Report message to a moderator

Previous Topic: Run Exp utility in background mode
Next Topic: import data in one tablespace
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Aug 28 23:57:42 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.