| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: LMT SYSTEM Tablespace? - SUMMARY
just for reference the package is dbms_space_admin and the procedure is tablespace_migrate_to_local
From: oracle-l-bounce_at_freelists.org on behalf of Hodgkinson, Stephen
Sent: Wed 24/03/2004 21:49
To: 'oracle-l_at_freelists.org'
Subject: RE: LMT SYSTEM Tablespace? - SUMMARY
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_at_firsthealth.com]
Sent: Thursday, 18 March 2004 3:44
To: oracle-l_at_freelists.org
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.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_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 Wed Mar 24 2004 - 16:33:23 CST---------------------------------------------------------------- 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 -----------------------------------------------------------------
- application/ms-tnef attachment: winmail.dat
 |
 |