Re: ORA-01658: unable to create INITIAL extent for segment in tablespace ACCOUNT

"Stephen_CA" <stephen.bell_at_sympatico.ca> wrote in message news:5aeee507.0308120453.5e223449_at_posting.google.com...
> "Sharad K" <sk_at_sk.com> wrote in message
news:<bha060$vvj6o$1_at_ID-192448.news.uni-berlin.de>...
> > Hi all,
> >
> > I was trying to update my schema on Oracle when I got the following
error
> > message.
> > "ORA-01658: unable to create INITIAL extent for segment in tablespace
> > ACCOUNT".
> > On googling I read that it meant that there was no free extent in the
> > tablespace system greater than or
> > equal to the extent size I was asking for.
> >
> > The ways it suggested me -
> > 1.Add a datafile.
> > 2.Resize the datafile if space available.
> >
> > Could anyone please explain me the problem more precisely and how to go
> > about
> > following either of the above steps (with their merits).
> >
> > Thanks in advance,
> > SK
>
> Hi,
>
> Oracle allocates space for segments (including tables) in units known
> as extents. The size of these extents is specified either when you
> create objects within a tablespace, when you create the tablespace
> itself, or using defaults.
>
> If your initial extent size was specified as, for example, 500 M, but
> your tablespace only holds 100M, it will not be possible to allocate
> the space for the initial extent..methods 1 and 2 that you've listed
> above will allow you to increase the size of the tablespace..to either
> resize a datafile or add a new one, use the ALTER TABLESPACE command.
> You can also recreate the table with a smaller initial extent if that
> is appropriate for your situation.
>
> I hope this helps,
>
> Steve

Hi Steve,
Thanks for the reply. Your description made the picture clear to me. I could rectify the error I was getting. Thanks again,
SK Received on Tue Aug 12 2003 - 08:21:51 CDT