| Version of exp and imp utilities [message #544620] |
Thu, 23 February 2012 01:49  |
 |
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
|
Senior Member |
|
|
Hi,
how to find the versions of exp and imp utilities of database server from windows command prompt?
Note:
Currently i have 10.2.0.10 oracle software installed on my local machine.
Regards
|
|
|
|
|
|
|
|
| Re: Version of exp and imp utilities [message #544693 is a reply to message #544623] |
Thu, 23 February 2012 06:01  |
|
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
|
Senior Member |
|
|
$ sqlplus jackdba/beautiful@ORCL2
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 23 06:55:10 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release [color=purple]10.2.0.4.0[/color] - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
$ exp help=y -----
Export: Release [color=purple]10.2.0.1.0[/color] - Production on Thu Feb 23 06:55:39 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Well if that is your answer then what would be the answer for this ?
|
|
|
|
| Re: Version of exp and imp utilities [message #544694 is a reply to message #544693] |
Thu, 23 February 2012 06:06 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
This is how I read it:
A database is 10.2.0.4.0.
You connected to it (using command prompt on your computer) using SQL*Plus version 10.2.0.1.0.
Your EXP version (on your computer) is 10.2.0.1.0 as well. This is not EXP version on a database server, but on your own PC. You do have EXP utility installed on your PC, don't you?
If you want to use EXP HELP=Y for a server's EXP version, you need to issue that statement on a server (not from your PC).
P.S. Forgot to mention: there's no problem in having more than a single Oracle product installed on a computer. For example, you could have Oracle 11g XE database (so that you can play with Apex), Oracle 10g Client (with utilities), Oracle 9i Client, etc.
Which one is used when you run EXP HELP=Y? The one that is first found in the PATH. If you want to use, for example, 9i EXP, change current directory to 9i's BIN directory (or include the whole path).
[Updated on: Thu, 23 February 2012 06:08] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
