Home » RDBMS Server » Server Utilities » Version of exp and imp utilities (10.2.0.10,windows)
Version of exp and imp utilities [message #544620] Thu, 23 February 2012 01:49 Go to next message
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 #544621 is a reply to message #544620] Thu, 23 February 2012 01:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
exp help=y

Regards
Michel
Re: Version of exp and imp utilities [message #544623 is a reply to message #544620] Thu, 23 February 2012 01:53 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, utilities version is equal to database version. So, if you connect to the database using SQL*Plus:
M:\>sqlplus scott/tiger@ora10

SQL*Plus: Release 11.2.0.2.0 Production on ╚et Vel 23 08:51:56 2012       --> SQL*Plus (client) version

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production    --> Database (EXP & IMP) version
With the Partitioning, OLAP and Data Mining options
Re: Version of exp and imp utilities [message #544693 is a reply to message #544623] Thu, 23 February 2012 06:01 Go to previous messageGo to next message
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 Go to previous message
Littlefoot
Messages: 21806
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

Previous Topic: Data Pump / Exp
Next Topic: EXP-00008: ORACLE error 933 encountered
Goto Forum:
  


Current Time: Fri Mar 29 03:22:37 CDT 2024