| 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: Local tablespaces, USER vs UNIFORM
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_at_comcast.net [mailto:mkline1_at_comcast.net]=20
Sent: Thursday, February 05, 2004 3:22 PM
To: oracle-l_at_freelists.org
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
"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."
 |
 |