RE: create table fails

Gary :
  In case 1, oracle tries to create the table in the default tablespace of the user.
The initial and next extent are derived from the tablespace definition regardless
of how much physical space is required. It also does not matter that the tablespace has
lots of space, what matters is the largest contiguous free space for the tablespace.
The view dba_free_space can give you the size of each available extent in the tablespace.

hope this helps

mar

> -----Original Message-----
> From: Gary Boyd [SMTP:gboyd_at_jccc.net]
> Sent: Wednesday, May 03, 2000 5:47 PM
> To: Multiple recipients of list ORACLE-L
> Subject: create table fails
>
> 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
>
> Gary
> --
> Author: Gary Boyd
> INET: gboyd_at_jccc.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed May 03 2000 - 16:21:20 CDT