OraFAQ Forum: Server Administration » import utilties commit option

Home » RDBMS Server » Server Administration » import utilties commit option

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

import utilties commit option [message #61251]

Wed, 07 April 2004 22:23

rakesh
Messages: 25
Registered: March 2001

Junior Member

hi

is there any option like

commit after n rows while importing in oracle 7.3 database

thanks

Report message to a moderator

Re: import utilties commit option [message #61253 is a reply to message #61251]

Wed, 07 April 2004 22:39

Anatol Ciolac
Messages: 113
Registered: December 2003

Senior Member

The best way to see this is run: imp help=y and to see the output or to see a documentation.

Report message to a moderator

Re: import utilties commit option [message #61266 is a reply to message #61251]

Thu, 08 April 2004 05:40

Thiru
Messages: 1089
Registered: May 2002

Senior Member

Use BUFFER and COMMIT import parameters to control the commit rate.

buffer_size = rows_in_array * maximum_row_size

Say ,the maximum_row_size is 200 and you want to commit approximately 1000 rows, you would use

buffer=1000*200=200000

But its recommended to minimize the number of commits during the import for performance reasons. If possible,I'd skip the commit and leave it to default.

-Thiru

Report message to a moderator

Previous Topic:	how to drop and recreate UNDO tablespace?
Next Topic:	startup database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:47:42 CDT 2024