set table or index unlimited or not

From: Mitchell <mitchell_at_comnet.ca>
Date: Fri, 29 Dec 2000 09:24:43 -0500
Message-Id: <10725.125447@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_014B_01C07179.2D9C1880 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi DBAs

Any suggestion for following questions?

Maxextents: total no of extents when you set the maxextents, How do you know that byte in size? is = it defined by Inital ( in bytes of the objects' first extent)?
is there anyway to monitor the situation like if setting for Next is = 10m, but Maxextents space reached over.

Mitchell

------=_NextPart_000_014B_01C07179.2D9C1880 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2><FONT face=3D"Times New Roman" =
size=3D3>Hi=20
DBAs</FONT></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><FONT face=3D"Times New Roman"=20
size=3D3></FONT></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Any suggestion  for following=20
questions?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>1. Maxextents: total no of =
extents</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>   when you set =
 the=20
maxextents, How do you know that byte in size?   is it defined = by=20
Inital ( in bytes of the objects' first extent)?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>2. is there anyway to monitor the =
situation like=20
if setting for Next is 10m, but Maxextents space reached=20 over.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2><FONT face=3D"Times New Roman"=20
size=3D3><BR><BR>Mitchell</FONT><BR><BR><BR></DIV></FONT></BODY></HTML> Received on Fri Dec 29 2000 - 08:24:43 CST