EXP-00008: ORACLE error 904 encountered ORA-00904: "IFREEPOOL": invalid identifier

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3 to 10.2.0.4
This problem can occur on any platform.

Symptoms

Export reports ORA-00904 "IFREEPOOL": invalid identifier while using a version 10.2.0.4.0 export client to export from a 10.2.0.3.0 database.

Export Log File 
--------------- 
. . Export der Tabelle CALCULATEDFIELDS 
EXP-00008: ORACLE-Fehler 904 aufgetreten 
ORA-00904: "IFREEPOOL": invalid identifier 

Cause

This is an expected behaviour.
The version of the Export utility must be equal to the earliest version of the source or target database. Here, the source database is based on release 10.2.0.3.0 and hence the export client has to be a version 10.2.0.3.0.
An export client of a later release cannot be used for the following reasons:

• The export utility is continuously accessing dictionary objects such as SYS.EXU9LOB.
• Starting with release 10.2.0.4.0 we introduced additional columns such as 'IFREEPOOL'. This column is not available in 10.2.0.3.0 and hence the client cannot handle this and ORA-00904/EXP-00008 appears.
  
  Client 10.2.0.4.0 is not supported to export from 10.2.0.3.0 database.

Solution

The version of the Export utility must be equal to the earliest version of the source or target database.