| Time taken by Export and Import [message #130741] |
Tue, 02 August 2005 04:00  |
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  |
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 |
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 |
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 |
 |
Mahesh Rajendran
Messages: 10708
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
