Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 8i to 9i and LMT

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: <>

I came across a problem where an LMT upgraded from 8i to 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 []
> Sent: Tuesday, February 24, 2004 9:29 AM
> To:
> 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 <>
> Reply-To:
> To: "''" <>
> 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:

To unsubscribe send email to: put 'unsubscribe' in the subject line.
Archives are at
FAQ is at
Received on Mon Feb 23 2004 - 16:59:34 CST

Original text of this message