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: RE: Locally Managed Tablespaces

RE: RE: Locally Managed Tablespaces

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 21 Mar 2003 16:14:04 -0800
Message-Id: <24738.322760@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C2F007.F2984D20
Content-Type: text/plain;

        charset="iso-8859-1"

I think minimum extent was a new parameter in 8.0.

> -----Original Message-----
> From: Jonathan Lewis [mailto:jonathan_at_jlcomp.demon.co.uk]
> 
> For 7.3 it is also important to set MINIMUM EXTENT
> for the tablespace to match the initial and next - then
> every extent has to be at worst a multiple of the minimum
> extent size whatever a rogue user does.

------_=_NextPart_001_01C2F007.F2984D20
Content-Type: text/html;

        charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: RE: Locally Managed Tablespaces</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>I think minimum extent was a new parameter in 8.0.</FONT>
</P>

<P><FONT SIZE=2>&gt; -----Original Message-----</FONT>
<BR><FONT SIZE=2>&gt; From: Jonathan Lewis [<A HREF="mailto:jonathan_at_jlcomp.demon.co.uk">mailto:jonathan_at_jlcomp.demon.co.uk</A>]</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; For 7.3 it is also important to set MINIMUM EXTENT</FONT>
<BR><FONT SIZE=2>&gt; for the tablespace to match the initial and next - then</FONT>
<BR><FONT SIZE=2>&gt; every extent has to be at worst a multiple of the minimum</FONT>
<BR><FONT SIZE=2>&gt; extent size whatever a rogue user does.</FONT>
</P>

</BODY>
</HTML>

------_=_NextPart_001_01C2F007.F2984D20-- Received on Fri Mar 21 2003 - 18:14:04 CST

Original text of this message

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