OraFAQ Forum: Server Utilities » import

Home » RDBMS Server » Server Utilities » import - how to make it faster

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

import - how to make it faster [message #194138]

Wed, 20 September 2006 23:20

oracledba_raja
Messages: 23
Registered: July 2006

Junior Member

Hi all,
Good Morning.
when import a .dmp file, how can make it faster?

Other than

igore = y

any specific approach?

Thanks.

Regards,
Raja

Report message to a moderator

Re: import - how to make it faster [message #194149 is a reply to message #194138]

Thu, 21 September 2006 00:26

Shamsher
Messages: 18
Registered: September 2006

Junior Member

Use Commit=N if you can efford to, Larger tables may not be suitable for this option due to the required rollback/undo space.

Use sufficient buffer size for better performance;
Buffer=Nk

Use no index while importing by specifying Index parameter with no option insist of that can generate a Indexfile which you can run later to recreate all indexes.
Index=N

last but not lease recommended on your own risk _disable_logging = true oracle hidden parameter to reduce redo log generation but import will be not recoverable in case of failure.

Imp xyz/xyz@xyz file=xyz.dmp index=N buffer=750000 commit=N indexfile-xyz.txt

Thanks and Regards
Shamsheer

Report message to a moderator

Re: import - how to make it faster [message #194219 is a reply to message #194138]

Thu, 21 September 2006 04:03

oracledba_raja
Messages: 23
Registered: July 2006

Junior Member

Thanks, Shamsheer.

Regards,
Raja

Report message to a moderator

Re: import - how to make it faster [message #194349 is a reply to message #194219]

Thu, 21 September 2006 10:49

ebrian
Messages: 2794
Registered: April 2006

Senior Member

In addition to what Shamsheer suggested, you may also want to consider setting STATISTICS=NONE. If you can't afford to disable the logging, then you could increase the size of your redo logs or for that matter if possible in your situation disable ARCHIVELOG.

Report message to a moderator

Re: import - how to make it faster [message #194391 is a reply to message #194138]

Thu, 21 September 2006 21:22

oracledba_raja
Messages: 23
Registered: July 2006

Junior Member

Thanks, ebrian.

Regards,
Raja

Report message to a moderator

Previous Topic:	data migration from excel file to oracle 9i
Next Topic:	exp on WIndows thru sqlplus

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 23:23:27 CST 2024