OraFAQ Forum: Server Utilities » Export -Import Speed up

Home » RDBMS Server » Server Utilities » Export -Import Speed up (Oracle10g)

Sun, 08 February 2009 23:07

sr_orcl
Messages: 82
Registered: January 2009
Location: mumbai

Member

Hi To All,

How can I reduced the time taken in Export and Import.
Please provide me some tips for reducing the time .

Thanks And Regards,
Sonali

Sun, 08 February 2009 23:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ROWS=NO

Mon, 09 February 2009 00:37

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

Senior Member
Account Moderator

Increase BUFFER
Don't work at the same time
Buy more memroy, faster disk and CPU.

Regards
Michel

Previous Topic:	import error 00017,imp-00003
Next Topic:	How to load data to Oracle Database using sql * loader?

Goto Forum:

]

Current Time: Thu Jul 31 16:41:05 CDT 2025