dba - minextents/maxextents

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. Received on Thu Nov 11 1999 - 16:35:40 CST