Re: Error on Table Creation ORA-01658

The Oracle Error Messge is described below with a hint to correct the problem.

You can either add a new datafile or retry creating table with smaller value of storage parameter INITIAL during the create time.

Manoj Jain
Oracle DBA

$ 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

Hassan Abba wrote:

> Add another datafile to the TABLESPACE, your tablespace has probably filled
> up. Then try and create the table.
>
> Regards
>
> Hassan Abba
> Oracle DBA/Developer
> Soft Options UK Ltd
>
> 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
Received on Thu Jan 22 1998 - 00:00:00 CST