OraFAQ Forum: Performance Tuning » import table having 30000000 rows

Home » RDBMS Server » Performance Tuning » import table having 30000000 rows (oracle9i,red hat linux rhel3, having only one processor,ram 1gb)

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

import table having 30000000 rows [message #409409]

Mon, 22 June 2009 08:18

suryakantnirala
Messages: 19
Registered: May 2009
Location: Mumbai

Junior Member

i have to import a table having 30000000 rows.
when i import it gets stuck. my server hardware configuration is
processor- 3.00 ghz(single)
ram- 1 gb
hard disk- 160 gb

what can i do now.
please help me.

Report message to a moderator

Re: import table having 30000000 rows [message #409417 is a reply to message #409409]

Mon, 22 June 2009 08:47

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Set buffer to the highest value than your RAM allows you without swapping (that is little given 1GB ram).

Drop the index before and recreate them after import.

Regards
Michel

Report message to a moderator