<robertncl_at_gmail.com> wrote in message
news:1145594187.531250.292720_at_v46g2000cwv.googlegroups.com...
> Hi,
>
> i have a oracle table that have run out of space, it is created with
> the following storage
>
> TABLESPACE xxxxx
> STORAGE (INITIAL 1000K
> NEXT 1000K
> PCTINCREASE 0
> MINEXTENTS 1
> MAXEXTENTS 122)
> ;
>
> how do i add more extend to the table??
>
Are you out of space in the tablespace or have you reached the maximum
number of extents? If max extents then
alter table ... storage( maxextents 255);
if you are out of space on in the tablespace then extend one of the
datafiles or add a datafile to the tablespace.
Jim
Received on Thu Apr 20 2006 - 23:58:29 CDT
