How to determine the software version of the database and the Data Pump client

In order to know your oracle database version issue,

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
CORE    11.1.0.6.0      Production
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

Alternatively, you can query from product_component_version.

SQL> col product for a40
SQL> col version for a11
SQL> col status for a15
SQL> select * from product_component_version;

PRODUCT                                  VERSION     STATUS
---------------------------------------- ----------- ---------------
NLSRTL                                   11.1.0.6.0  Production
Oracle Database 11g Enterprise Edition   11.1.0.6.0  Production
PL/SQL                                   11.1.0.6.0  Production
TNS for 32-bit Windows:                  11.1.0.6.0  Production

In order to see your Export data pump client version issue from command prompt,

C:\>expdp help=y

Export: Release 10.2.0.1.0 - Production on Wednesday, 04 February, 2009 1:33:23

Copyright (c) 2003, 2005, Oracle. All rights reserved.

In order to see your Import data pump client version issue from command prompt,
C:\>impdp help=y

Import: Release 10.2.0.1.0 - Production on Wednesday, 04 February, 2009 1:32:44

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Both in case of Data Pump Export and Import first few digits show it version.

Related Documents

New features in Oracle database 11g of data pump utility

New features of oracle perfomance in 10.2g

List of Oracle Database Version Release.

Timeline of Oracle RDBMS Major Release Version.