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:Rich.Jesse_at_qtiworld.com]
>
> 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.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jacques Kilchoer
INET: Jacques.Kilchoer_at_quest.com
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 Tue Jul 30 2002 - 19:43:19 CDT
