Local tablespaces, USER vs UNIFORM

From: <mkline1_at_comcast.net>
Date: Thu, 05 Feb 2004 20:22:07 +0000
Message-Id: <020520042022.17071.2163@comcast.net>

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_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 Thu Feb 05 2004 - 14:22:07 CST