Xref: alice comp.databases.oracle.server:73631
Path: alice!news-feed.fnsi.net!news.idt.net!newsfeed.mathworks.com!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: Nandakumar <N.Kumar@rocketmail.com>
Newsgroups: comp.databases.oracle.server
Subject: dba - minextents/maxextents
Date: Thu, 11 Nov 1999 22:35:40 GMT
Organization: Deja.com - Before you buy.
Lines: 32
Message-ID: <80fgbs$hib$1@nnrp1.deja.com>
X-Article-Creation-Date: Thu Nov 11 22:35:40 1999 GMT
X-Http-User-Agent: Mozilla/4.51 [en] (WinNT; I)
X-Http-Proxy: 1.0 x23.deja.com:80 (Squid/1.1.22) for client 209.117.251.206
X-MyDeja-Info: XMYDJUIDnanban

hi

if a tablespace is created with the following definition
crteate tablespace ts_1 datafile 'x' size 1000 M
storage (
initial 100M
next 50 M
minextents 1
maxextents 20
)

what would be the maximum size that a table (all using default
storage) in the tablespace can grow?

In the above example,
Is it a good practise to define the maxextents as 1000/50=40?
( Would it let a table in need take all available space and make no more
space available for other tables?? )

If maxextents is 40, is it same as defining maxextents UNLIMITED?

Is there any use of defining minextents when its value is 1?

if any of the questions is irrelevant, i guess i desperately need to
know what these MINEXTENTS and MAXEXTENTS are?

Thanks
Nanda


Sent via Deja.com http://www.deja.com/
Before you buy.