RE: 9.2.0.6 or 9.2.0.7 for AIX 5.3 (64 bit)

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_at_tax.state.vt.us] 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_at_tax.state.vt.us <mailto:rgramolini_at_tax.state.vt.us>

--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 12 2005 - 09:23:07 CDT