>From out of nowhere, I started getting the 'ORA-01658: unable to create
INITIAL extent for segment ...' error for only SOME indexes on my index
tablespace when doing a simple import. Export was done without compression.
I rechecked INITIAL extent sizes and true to my expectations they were small
665K. I didn't want to go through precreating the tables with appropriate
sizes because I felt it was not the issue in the first place. As a last
resort I restarted the database and everything went back to normal again.
Can anybody have an explanation for this?
Thanks,
George
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: George Hofilena
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).