Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> create table fails

create table fails

From: Gary Boyd <gboyd_at_jccc.net>
Date: Wed, 03 May 2000 15:40:26 -0500
Message-Id: <10486.104859@fatcity.com>


Here's a weird one:

  1. Tried creating a table from a subquery as follows:

create table tab1 as select * from tab2

the following error is generated: ORA-01658: unable to create INITIAL extent for segment in tablespace name

2) when creating a table with explicit structures and storage parameters

   the creation is successful

In both cases above the user is logged in as dba and default tablespace (the same for both cases too) is unfragmented with plenty of space. Moreover, in case 1 the space needed for the initial extent is only 35k and in case 2 the space for the initial extent is 1 meg

Any ideas?

7.3.4 on AIX Received on Wed May 03 2000 - 15:40:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US