Oracle-L: RE: upgrade or install?

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 01 May 2003 14:31:38 -0800
Message-ID: <F001.0058DBF5.20030501143138@fatcity.com>

Joe

Either way you will want to completely install 9i. ;-) If you mean should you upgrade your 8.0.5 database or exp/imp the data into 9i, personally I make the decision based on how large the database is. If it can be exported/imported within the downtime window you are given, that is my first choice. If not, then I upgrade, performing the procedure on the test system first. This upgrade is not a big deal, other than making sure your application, system, etc. are all compatible.

Dennis Williams
DBA, 60%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, May 01, 2003 4:52 PM
To: Multiple recipients of list ORACLE-L

IS it easy to upgrade from Oracle 8.0.5 to 9i or should I just do a complete install of 9i.

Joe

-----Original Message-----
Sent: Thursday, May 01, 2003 2:07 PM
To: Multiple recipients of list ORACLE-L

It says that you are supposed to commit or rollback before doing parallel dml on the object.
But you can still get the error since there is a bug in 9.2 which will be fixed in Oracle 10.
we were hit by this bug and had to request a back port to come with a patch for 9.2.

The patch is available now for 9.2 Solaris (and probably AIX).

Regards,

Waleed

-----Original Message-----
Sent: Thursday, May 01, 2003 4:32 PM
To: Multiple recipients of list ORACLE-L

here is what it says on OTN. Not sure what it means.

ORA-12838 cannot read/modify an object after modifying it in parallel

Cause: Within the same transaction, an attempt was made to add read or modification statements on a table after it had been modified in parallel or with direct load. This is not permitted.

Action: Rewrite the transaction, or break it up into two transactions: one containing the initial modification and the second containing the parallel modification operation.

INSERT /*+append*/INTO tab1(col1)

SELECT col1
FROM tab2
where col2 in (select col2

                  from tab2
                 minus
                  select to_number(col3)
                 from tab1
                 where col4 <> 'XX')

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: <rgaffuri_at_cox.net
INET: rgaffuri_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Khedr, Waleed
INET: Waleed.Khedr_at_FMR.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------