Re: Error on Table Creation ORA-01658

Or it could also be that you need to reorg or coalese your tablespace if you a have version 7.2 or less and you feel that you have adequate space but most of these space is not contigously stored ...

Mark's recomendation should work fine .

Mark Rothstein wrote:
>
> > oerr ora 1658
> 01658, 00000, "unable to create INITIAL extent for segment in tablespace
> %s"
> // *Cause: Failed to find sufficient contiguous space to allocate
> // INITIAL extent for segment being created.
> // *Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to
> // the tablespace or retry with a smaller value for INITIAL
>
> M.Puig wrote:
> >
> > Trying to create a new table on Oracle 7.1.5.2 over OpenVMS 6.2 1H3 the
> > following error occurs:
> > ORA-01658 Unable to create INITIAL extent for segment in tablespace
> > HISTORIA.
> > This error is not reported in Oracle manuals, nor in paper, nor in CD-ROM
> > format.
> > Why it happens? What does it mean? How can I solve it?
> >
> > Thanks,
> >
> > Miquel Puig
>
> --
>
> Mark Rothstein
> markr_at_xxxsnet.net
>
> Remove 'xxx' to reply.
Received on Mon Jan 12 1998 - 00:00:00 CST