Be careful with 9.2.0.7. It cannot export from lower versions of Oracle. I didn't have any other problems, but this one is a big one. The compatibility with the previous releases is broken. After closer inspection, DBMS_EXPORT_EXTENSION package has 3 more units in 9.2.0.7 then in 9.2.0.5: FUNCTION CHECK_MATCH_TEMPLATE RETURNS NUMBER(38) FUNCTION FUNC_INDEX_DEFAULT RETURNS VARCHAR2 FUNCTION NULLTOCHR0 RETURNS VARCHAR2 The error I am getting is: . exporting table DEF$_AQCALL 0 rows exported EXP-00056: ORACLE error 904 encountered ORA-00904: "SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT": invalid identifier This is yet another Oracle patchset to have QA done by customers. I have a TAR open about this and support analysts are dragging their feet. I should forward this to Mr. Scott Adams. -- Mladen Gogala Ext. 121 _____ From: Ruth Gramolini [mailto:rgramolini@xxxxxxxxxxxxxxx] Sent: Wednesday, October 12, 2005 9:46 AM To: oracle-l Subject: 9.2.0.6 or 9.2.0.7 for AIX 5.3 (64 bit) Good morning, We are finally going to update our 9.2.0.4 installation and we are also going to upgrade AIX from 5.2 to 5.3. Does anyone have any insights as to which version 9.2.0.6 or 9.2.0.7 is better or worse. I know there have been some problems with 9.2.0.6 but I am not familiary with problems specifie to AIX 5.3. Any insights will be welcome! Thanks in advance, Ruth Gramolini Oracle DBA Vermont Department of Taxes Phone 802-828-5708 Email rgramolini@xxxxxxxxxxxxxxx <mailto:rgramolini@xxxxxxxxxxxxxxx>