| 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: LOCALLY MANAGED TABLESPACE
In a 'converted/migrated' LMT, tables/indexes can not take advantage of
UNIFORM or SYSTEM (autoallocate) policy of extent management. Those objects
still grow with their old 'next' extent sizes. For full benefits of LMT,
consider creating new LMT tablespaces and moving objects to them. Search
Metalink. There are a number of documents/notes on converting DMT to LMT.
-----Original Message-----
Sent: Friday, October 25, 2002 8:04 AM
To: Multiple recipients of list ORACLE-L
The only issue we faced was convincing the management that in LMT having 150 extents is not really a problem.
Raj
QOTD: Any clod can have facts, but having an opinion is an art!
-----Original Message-----
Sent: Thursday, October 24, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L
Hi
I am thinking to change our few dictinary manages tablespace to locally
managed tablespace.Can any one experienced any issues with locally managed
tablespace?
Do any one experience what gain after changing to locally managed
tablespace?
Thx
-Seema
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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). Received on Fri Oct 25 2002 - 09:28:34 CDT
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |