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

  • From: "Gogala, Mladen" <MGogala@xxxxxxxxxxxxxxxxxxxx>
  • To: "'rgramolini@xxxxxxxxxxxxxxx'" <rgramolini@xxxxxxxxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 12 Oct 2005 10:21:19 -0400

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>  

Other related posts: