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

"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 Received on Tue Aug 12 2003 - 07:53:22 CDT