Home » Infrastructure » Windows » Time taken by Export and Import
Time taken by Export and Import [message #130741] Tue, 02 August 2005 04:00 Go to next message
bhagwan
Messages: 86
Registered: September 2004
Member
Hi,

Iam firing an imp/exp command on my Win 2000 Professional desktop.

Although it gets executed successfully, Iam interested to know the time taken.Like we can do 'set time on' in sql promt which helps in calculating the time taken for a sql or pl/sql unit to get executed.

Similarly, I wanted to know if we can do same in windows command prompt.Do we need to write some batch file for it? If so, can someone help me with that and also tell me where to place this file.

Regards,
Bhagwan

Re: Time taken by Export and Import [message #130755 is a reply to message #130741] Tue, 02 August 2005 05:29 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Its just a trick that i m trying to do, lets see whether it works for u or not. Try to play with this command.

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.


C:\>time >> f1 | dir | time >>f2

C:\>type f1
The current time is: 15:52:29.00
Enter the new time: The current time is: 15:53:08.79
Enter the new time:

C:\>type f2
The current time is: 15:53:08.82
Enter the new time: Volume in drive C has no label.
The system cannot accept the time entered.
Enter the new time: 5:28 PM 3,081 detail1.txt


u can insert ur imp/exp command replacing dir command in above example.check it out on ur command prompt.

regards,
tarun

[Updated on: Tue, 02 August 2005 05:30]

Report message to a moderator

Re: Time taken by Export and Import [message #130760 is a reply to message #130755] Tue, 02 August 2005 05:49 Go to previous messageGo to next message
bhagwan
Messages: 86
Registered: September 2004
Member
Tarun,

Your trick isnt exactly clear to me.

I didn't understand what do you mean when you say "(here u can use ur imp/exp command)"..

C:\> time >> f1 | dir (here u can use ur imp/exp command) | time >>f2

Do you mean that I create a text file where I need to add my imp command (say filename:xyz.txt) ?

Pls elaborate.

Regards,
Bhagwan
Re: Time taken by Export and Import [message #130765 is a reply to message #130755] Tue, 02 August 2005 06:40 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Hi bhagwan ,

Lets give it a try.

See, u can create a PARFILE for import/export command and then when u use a combination of these commands.

Here is an exact example and now i think it should work for u.

>> create a dummy file

Quote:

C:\>copy con f3
TIME UP
^Z
1 file(s) copied.


( this file is created so that command should not hault for input )

>> Now run ur export command

Quote:

C:\>time > f1 < f3 & exp userid=tarun/tarun tables=emp file=c:\expfile.dmp & time > f2 < f3

Export: Release 9.2.0.1.0 - Production on Tue Aug 2 05:07:06 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


EXP-00056: ORACLE error 28011 encountered
ORA-28011: the account will expire soon; change your password now
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table EMP 14 rows exported
Export terminated successfully without warnings.




>> Now after the completion of the command u can see the contents of file f1 and f2 to see the time difference.

Quote:


C:\>type f1
The current time is: 5:07:06.82
Enter the new time: TIME UP
The system cannot accept the time entered.
Enter the new time:
C:\>type f2
The current time is: 5:07:07.04
Enter the new time: TIME UP
The system cannot accept the time entered.
Enter the new time:




regards,
tarun
Re: Time taken by Export and Import [message #130788 is a reply to message #130760] Tue, 02 August 2005 09:08 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
--
-- would'nt a simple batch file do this?
-- one.bat is the file.
--
C:\>one > one.log

Export: Release 9.2.0.1.0 - Production on Tue Aug 2 10:07:47 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SCOTT
About to export SCOTT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SCOTT's tables via Conventional Path ...
. . exporting table                    ANOTHER_EMP     196608 rows exported
. . exporting table                           DEPT          4 rows exported
. . exporting table                            EMP     458752 rows exported
. . exporting table                     PLAN_TABLE          0 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.

C:\>type one.log
current time is
10:07a
ECHO is off.
current time is
10:08a

C:\>type one.bat
@echo off
echo current time is
time /t
exp scott/tiger@mutation owner=scott
echo
echo current time is
time /t


Update:
add another
echo starting export in one.bat, before doing the export.

[Updated on: Tue, 02 August 2005 09:09]

Report message to a moderator

Previous Topic: Need a windows script to determine free memory!
Next Topic: Errors when trying to connect to Orable from VBA using OraOLEDB.Oracle
Goto Forum:
  


Current Time: Fri Mar 29 06:16:11 CDT 2024