OraFAQ Forum: Server Utilities » How to find estimated time to complete import (imp)

Home » RDBMS Server » Server Utilities » How to find estimated time to complete import (imp) (Oracle-9i database / Sun OS)

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

How to find estimated time to complete import (imp) [message #551399]

Tue, 17 April 2012 23:59

sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI

Member

Hi

I am using imp / Schema level.
Dump file contains 3 schemas with 120 GB size.Imp is running now.
How to find completion time. So that I can inform to application developer about activity completion time.

Thanks in advance
sbmk

Report message to a moderator

Re: How to find estimated time to complete import (imp) [message #551408 is a reply to message #551399]

Wed, 18 April 2012 00:59

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As far as I can tell, you can't know that information. Approximately, if you know the time export took to create a DMP file, import will take at least that much, but most probably longer. Export (import) data pump offers the ESTIMATE_ONLY parameter, but it calculates only "size", not "time".

Report message to a moderator

Re: How to find estimated time to complete import (imp) [message #551411 is a reply to message #551399]

Wed, 18 April 2012 01:03

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

Senior Member
Account Moderator

There is no way to estimate time as it depends on so many things that are in your control or not.
The only way for you is to have done similar import(s) in this environment and then estimate this one from your experience.

Regards
Michel

Report message to a moderator

Re: How to find estimated time to complete import (imp) [message #551426 is a reply to message #551399]

Wed, 18 April 2012 03:50

sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI

Member

Thanks..
is it possible to see how much percentage import has compleated

Regards
sbmk

Report message to a moderator

Re: How to find estimated time to complete import (imp) [message #551428 is a reply to message #551426]

Wed, 18 April 2012 04:22

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://www.orafaq.com/forum/t/48107/2/
Still no direct method to monitor the % completed.

Report message to a moderator

Previous Topic:	schema not found
Next Topic:	second enclosure string not present in sqlldr

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 16:18:32 CST 2025