Re: Database Size

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 20 May 2002 09:35:54 +0200
Message-ID: <uehb6vem74iu6a@corp.supernews.com>

"Kram" <marky_at_atex.com.au> wrote in message news:qz0G8.42$xx.3214_at_nsw.nnrp.telstra.net...
> When I build a table, using NEXT 225280 will this extended over the
initial
> tablespace size or will the tablespace grow with the size of my table.
>
>

If with next you mean the next extent clause of the table, the table's next extent in the existing tablespace will be 225280 bytes. The tablespace itself will extend only when you changed the datafiles into auto extend, and there is no more space available.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Mon May 20 2002 - 02:35:54 CDT