UNLIMITED TABLESPACE vs MAXEXTENTS...
sgalaxySep 29 2007 — edited Sep 29 2007Hi,
Let's assume that :
1)a db user has been granted the UNLIMITED TABLESPACE privilege....
2)all tables's extents he created have been full ....
3)the tables's maximum number of extents has been reached....
4)there is almost no other free tablespace empty..... so , it must be resized....
when a/some records in one table are going to be inserted.... what may happen....????
1) because of the maxextents number has been reached... so as there is no possibility another extent(s) to be added..., the records will not be inserted....????
2) because of the UNLIMITED TABLESPACE... the tablespace would be resized and as a result the records... will be inserted....????
In other words....which one is prevailing....
the UNLIMITED TABLESPACE.... or MAXEXTENTS .....????
Thanks... a lot
Sim