Michael,=20
You can migrate the tablespace to local and assign either USER or
SYSTEM for the extent allocation algorithm. It's not going to affect
the existing extents. =20
By the way, SYSTEM allocation works very, very well. I gave up on
trying to manage the extent sizes a long time ago.=20
Lisa Koivu
Senior Monkey
Orlando, FL, USA
-----Original Message-----
From: mkline1@(protected)
Sent: Thursday, February 05, 2004 3:22 PM
To: oracle-l@(protected)
Subject: Local tablespaces, USER vs UNIFORM
If all extents are say, 10 meg, and a tablespace is local with 10m
initial and 10 meg next and USER, and everything that does exist is 10
meg, can it be converted to uniform 10M extents?
It seems early DBA's were not very consistent. Some tablespaces are
USER, some UNIFORM, some are still Dictionary which may be the reason
for USER if they wer simply converted.
This is 8.1.7.4 on HP.
Thanks.
--
Michael Kline, Principle Consultant
Business To Business Solutions
13308 Thornridge Ct
Midlothian, VA 23112
804-744-1545
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
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
-----------------------------------------------------------------
"The sender believes that this E-Mail and any attachments were free of =
any virus, worm, Trojan horse, and/or malicious code when sent. This =
message and its attachments could have been infected during =
transmission. By reading the message and opening any attachments, the =
recipient accepts full responsibility for taking proactive and remedial =
action about viruses and other defects. The sender's business entity is =
not liable for any loss or damage arising in any way from this message =
or its attachments."
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
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
-----------------------------------------------------------------
