Re: Newbie DBA Question: ORA-01658

From: Mark Styles <news_at_lambic.co.uk>
Date: Tue, 30 Oct 2001 17:00:08 GMT
Message-ID: <a0nttt4phe0i7on3mejlt9nnev175stp21@4ax.com>

On 30 Oct 2001 08:40:32 -0800, jerryli60540_at_yahoo.com (Jerry Li) wrote:
>ORA-01658: unable to create INITIAL extent for segment in tablespace
>TASDEVT_INDEXES_VOD
>
>What do I need to do?

oerr ora 1658 gives us:

01658, 00000, "unable to create INITIAL extent for segment in tablespace %s"

// *Cause:  Failed to find sufficient contiguous space to allocate 
//          INITIAL extent for segment being created.
// *Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space 
//            to the tablespace or retry with a smaller value for

INITIAL You can also try coalescing space in the tablespace. Received on Tue Oct 30 2001 - 11:00:08 CST