we got a error message when export user data from 10.2.0.3 database using 10.2.0.4 oracle client..
exporting table TKEYTAB
EXP-00008: ORACLE error 904 encountered
ORA-00904: “IFREEPOOL”: invalid identifier
some notes may help as remind.
Oracle Server – Enterprise Edition – Version: 10.2.0.3 to 10.2.0.4
This problem can occur on any platform.
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.
The version of the Export utility must be equal to the earliest version of the source or target database.
None. – This is an expected behaviour.