Home » RDBMS Server » Server Utilities » SQLLDR and commit issues
SQLLDR and commit issues [message #123141] Fri, 10 June 2005 02:12 Go to next message
puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India
Member

Hi Group,

I need to work on sqlldr commit thing.
It is committing for every 64 rows but we need to ensure that the whole import is committed as a single transaction.

Is there any change in control File is required.

Plz let me know its very urgent for me.
I'm stuck in this.

Puneet Sachar
Re: SQLLDR and commit issues [message #123162 is a reply to message #123141] Fri, 10 June 2005 04:28 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can use ROWS option.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch04.htm#1004873
Previous Topic: Error importing converted datafile
Next Topic: Error trying to import stats
Goto Forum:
  


Current Time: Thu Jul 04 06:41:54 CDT 2024