Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Local tablespaces, USER vs UNIFORM

RE: Local tablespaces, USER vs UNIFORM

From: Koivu, Lisa <Lisa.Koivu_at_Cendant-TRG.com>
Date: Thu, 5 Feb 2004 15:46:37 -0500
Message-ID: <840C139B79E7CC4496B2594E9E35E967041926A2@floexmailbe2.ffci.com>


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



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

"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_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:46:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US