Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> create table fails
Here's a weird one:
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
![]() |
![]() |