RE: LMT SYSTEM Tablespace? - SUMMARY
- From: "Hodgkinson, Stephen" <Stephen.Hodgkinson@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Mar 2004 08:49:56 +1100
Tom mentions the issue of LMT and System:
In one of his articles : "Converting Dictionary Managed to LMT tablespace",
http://asktom.oracle.com/pls/ask/f?p=4950:8:6709117994285291480::NO::F4950_P
8_DISPLAYID,F4950_P8_CRITERIA:1163235055159,
When talking about the package - tablespace_migrate_to_local he discourages
it use and says:
' Not really, a migrated tablespace won't have the bitmaps at the "front"
like a
natural one would. '
Can anybody tell me what that means? - "bitmaps at the front".
A bit of Background:
We are discussing if we should change our System tablespace to LMT using the
package tablespace_migrate_to_local.
All our other tablespaces are already LMT. We will be moving to RAC soon and
thing it would be better to have everything LMT as documents on RAC seem to
continually recommend LMT.
As we can not do an import/export of our database we are considering using
the package tablespace_migrate_to_local.
thanks,Stephen.
-----Original Message-----
From: Stephen Andert [mailto:StephenAndert@xxxxxxxxxxxxxxx]
Sent: Thursday, 18 March 2004 3:44
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: LMT SYSTEM Tablespace? - SUMMARY
Thanks to all who replied. Ruth, Dennis, Tom & Hemant.
Excerpts from the replies are below.
Based on this, I think we are proceeding as we have been. That is to
say, databases that are upgraded are keeping SYSTEM as DMT and new
installs will get LMT for SYSTEM. For all other tablespaces, we are
moving to LMT.
Thanks!
Stephen Andert
>>>>>>
I see no good reason why to change the SYSTEM tablespace to an LMT. I
say
wait until Oracle says it is required and then do it. Probably in
10G.
It's working as it is, so I would leave it alone.
>>>>>>
I use LMT SYSTEM in 9.2.0.2 and 9.2.0.4 on Tru64 and Solaris without
any issues
>>>>>>
Yes, in 9i LMT is the default for system tablespace and if that is LMT
you cannot create a
DMT. Haven't tried it, just quoting.
>>>>>>
In earlier versions the system tablespace was not supposed to be
locally
managed. In 9.2.0.x you can and probably should make it locally
managed.
I just did this on my production databases.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
************** IMPORTANT MESSAGE **************
This e-mail message is intended only for the addressee(s) and contains
information which may be confidential. If you are not the intended recipient
please advise the sender by return email, do not use or disclose the contents,
and delete the message and any attachments from your system. Unless
specifically indicated, this email does not constitute formal advice or
commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123
124) or its subsidiaries.
**************************************************
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
