Error on Table Creation ORA-01658

Error on Table Creation ORA-01658

Post by M.Pui » Tue, 13 Jan 1998 04:00:00



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

 
 
 

Error on Table Creation ORA-01658

Post by James Pett » Tue, 13 Jan 1998 04:00:00



> 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.

Appropriate message is below. It means there is not enough contiguous
free space to allocate the initial extent for your
table.

ORA-01658 unable to create INITIAL extent for segment in
          tablespace name
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.

--
James "I'd rather fall off Ilustrada than ride any other horse" Petts

 
 
 

Error on Table Creation ORA-01658

Post by Mark Rothstei » Tue, 13 Jan 1998 04:00:00


Quote:> 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


> 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

Remove 'xxx' to reply.

 
 
 

Error on Table Creation ORA-01658

Post by raide » Tue, 13 Jan 1998 04:00:00


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 .


> > 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


> > 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

> Remove 'xxx' to reply.

 
 
 

Error on Table Creation ORA-01658

Post by Ken Frida » Tue, 13 Jan 1998 04:00:00


Miquel,

"oerr" a unix utility for looking up Oracle error msg on my HP indicates:

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

Hope this helps.
Ken F.


Quote:> 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

 
 
 

Error on Table Creation ORA-01658

Post by Hassan Abb » Fri, 16 Jan 1998 04:00:00


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


> 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

 
 
 

Error on Table Creation ORA-01658

Post by Kaboel Kar » Fri, 16 Jan 1998 04:00:00


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



>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


>> 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

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

 
 
 

Error on Table Creation ORA-01658

Post by Manoj Jai » Fri, 23 Jan 1998 04:00:00


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
$

===============


> 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


> > 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

 
 
 

1. ora-01658,unable to create initial extent for segment in table space system

Hi,
  I was trying to intall jServer in Oracle 8i using the script
initjvm.sql, and I got thew follow. error
ora-01658,unable to create initial extent for segment in table space
system
  Can somebody please tell me what does it mean.I referred the
documentation, it says alter the tablespace and add a data file with
smaller initial extent.I tried this also but it does not work.
help will be appreciated,
regards,
Anurag


* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!

2. error while installing

3. "ORA-01555 snapshot too old and ORA-01658 unable to create

4. Simplified Chinese translation file for nls support

5. ORA-01658: unable to create INITIAL extent for segment in tablespace

6. Cannot read from drive D

7. Newbie DBA Question: ORA-01658

8. User functions in Access Stored Queries accessing through VB

9. Recover Tablespace with IMPORT and get ORA-01658

10. ORA-01658: unable to create INITIAL extent for segment in tablespace

11. ORA-01658: unable to create INITIAL extent for segment in tablespace DES2

12. ORA-01658. Puzzling =(

13. ORA-01658: unable to create INITIAL extent for segment in tablespace