RE: 8i to 9i and LMT

From: Lim, Binley <Binley.Lim_at_NBNZ.CO.NZ>
Date: Tue, 24 Feb 2004 12:02:09 +1300
Message-ID: <5FA85DB5FB07D7118CF50002A5754C0902E2C9EF@nbnzhexch2.nbnz.co.nz>

I came across a problem where an LMT upgraded from 8i to 9.2.0.3 became corrupted when a shutdown abort was performed when there still was update activities on the tablespace.

The symptom was ORA-600s when querying the data dictionary on that tablespace - the tables themselves did not give any problems. None of the fix-it dbms packages were of any good - they errored out when trying to executed them. Since the tables themselves could be moved without any problems - the solution was to simply rebuild the tablespace.

I suspect it has something to do with the tablespace starting life as DMT in 8.0, migrated to LMT using the supplied packages in 8i, and subsequently upgraded to 9i, as testing on 9i brand-new LMTs did not give any problems. This was off-course a dispensable tablespace - I wasn't brave enough to subject the others to this migration process.

> -----Original Message-----
> From: M Rafiq [SMTP:rafiq9857_at_hotmail.com]
> Sent: Tuesday, February 24, 2004 9:29 AM
> To: oracle-l_at_freelists.org
> Subject: RE: 8i to 9i and LMT
>
> Ask him to be more specific. Recently done couple of upgrades on
> Windows/Linux without any issues. Almost all tablespces were LMT's.
>
> Regards
> Rafiq
>
>
>
>
> From: Michael Milligan <Michael.Milligan_at_ingenix.com>
> Reply-To: oracle-l_at_freelists.org
> To: "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>
> Subject: 8i to 9i and LMT
> Date: Mon, 23 Feb 2004 14:22:14 -0600
>
> A DBA just mentioned to me that Oracle has trouble with locally managed
> tablespaces when upgrading from 8i to 9i. Has anyone seen this or heard of
> this being an issue?
>
> Thanks,
>
> Mike Milligan
>
>
>

This communication is confidential and may contain privileged material. If you are not the intended recipient you must not use, disclose, copy or retain it. If you have received it in error please immediately notify me by return email and delete the emails.
Thank you.

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Feb 23 2004 - 16:59:34 CST