Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Database Size

Re: Database Size

From: A.Liggins <A.Liggins_at_hotmail.com>
Date: Wed, 22 May 2002 18:13:29 +0000 (UTC)
Message-ID: <acgn48$rfj$1@helle.btinternet.com>


[Please be aware that AUTOEXTEND means that you may one day discover someones insert into a table went
wrong and you have no disk space left... Use with caution and put some limits on it if you do.]

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:uehb6vem74iu6a_at_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 Wed May 22 2002 - 13:13:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US