Could it be because of the minimum extent size? Though I would think it unlikely that your minimum extent size would be greater than 147MB.
> -----Original Message-----
> From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
>
> On 8.1.7.2.0 on HP/UX 11.0, I need to create an index online.
> So, I see how
> much space I have:
>
> select max(bytes/1024/1024)
> from dba_free_space
> where tablespace_name = 'MY_IDX_TS';
>
> ...and it returns "147.3475". So I create my index:
>
> CREATE INDEX myschema.mycoolidx
> ON myschema.mycooltbl(mycoolcol) PCTFREE 15
> STORAGE(
> INITIAL 140 M
> NEXT 30 M
> )
> NOLOGGING ONLINE TABLESPACE my_idx_ts PARALLEL 2;
>
> But I keep getting "ORA-01658 unable to create initial extent
> in MY_IDX_TS",
> even though there is ample room. I thought it was because I
> had originally
> tried it with "PARALLEL 2" and there was some overhead needed, so I
> coalesced the TS (DICTIONARY, obviously) and tried it without
> the PARALLEL
> to no avail. I've even dropped the INITIAL down to 130M
> without luck (again
> after coalescing). Oh, to be LOCAL...
>
> So, how big can I make the initial extent? I don't remember
> running into
> this before and I can't find anything on MetaLink. And of
> course, I killed
> the session when it was creating it so now I can't drop the
> index without a
> ORA-8104 error.
