Re: Error on Table Creation ORA-01658

What it actually says, is that there is no contigues space to allocate for your initial extend. Maybe you do have enough space. Query 'DBA_FREE_SPACE'. Cheers

On Thu, 15 Jan 1998 15:07:12 +0000, Hassan Abba <hassan_at_softopt.co.uk> 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
>
>

Kaboel Karso

Consultant

                                                           \\\|///
                             \\  ~ ~  //
                             (  @ @  )
==========================-oOOo-(_)-oOOo-===================

eSCOSYS Consultancy		Phone	: +31 (0)32 024 7285
Horst 2827			Fax	: +31 (0)32 024 7286	
8225 MZ Lelystad		Mobile	: +31 (0)65 498 5413
The Netherlands			email	: kkarso_at_knoware.nl

==================================-Oooo.-===================
                         .oooO     (   )
                          (   )      ) /
                           \ (      (_/