Home » RDBMS Server » Server Utilities » How to find estimated time to complete import (imp) (Oracle-9i database / Sun OS)
How to find estimated time to complete import (imp) [message #551399] Tue, 17 April 2012 23:59 Go to next message
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
Re: How to find estimated time to complete import (imp) [message #551408 is a reply to message #551399] Wed, 18 April 2012 00:59 Go to previous messageGo to next message
Littlefoot
Messages: 21528
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".
Re: How to find estimated time to complete import (imp) [message #551411 is a reply to message #551399] Wed, 18 April 2012 01:03 Go to previous messageGo to next message
Michel Cadot
Messages: 66773
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: How to find estimated time to complete import (imp) [message #551426 is a reply to message #551399] Wed, 18 April 2012 03:50 Go to previous messageGo to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Thanks..
is it possible to see how much percentage import has compleated

Regards
sbmk
Re: How to find estimated time to complete import (imp) [message #551428 is a reply to message #551426] Wed, 18 April 2012 04:22 Go to previous message
Mahesh Rajendran
Messages: 10690
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.
Previous Topic: schema not found
Next Topic: second enclosure string not present in sqlldr
Goto Forum:
  


Current Time: Fri Jan 17 23:56:13 CST 2020