Re: unable to create INITIAL extent for segmentintablespace

From: Howard J. Rogers <howardjr_at_www.com>
Date: 2000/07/16
Message-ID: <39711498$1@news.iprimus.com.au>#1/1

Failure to create a NEXT extent can be caused by all sorts of things. But failure to create an INITIAL extent usually comes down to not having enough space in the tablespace.

Make sure the tablespace is suitably large. Also make sure that it doesn't have any silly parameters set (like MINIMUM EXTENT of 10Gb or something equally daft!).

Regards
HJR "Kim Ammouche" <kim_at_ammouche.net> wrote in message news:MPG.13dad291d3a0e2f9896a5_at_news.enitel.no...
> After changing the OS from NT4 to Win2000 on a development server I have
> trouble restoring the data.
>
> While using to IMP80 utility to import data previous exportet using the
> EXP80 i get the following message.
>
> I have created the user that the data beloings to along with the
> tablespace.
>
>
> The tablescpace webspace is the default space for this user and the user
> has a quota there.
>
> The message says:
>
> IMP-00003: Oracle error 1658 encountered
> ORA-01658: unable to create INITIAL extent for segment in tablespace
> WEBSPACE
>
>
> Any hits will be apretiated.
>
> -
> Mvh - Kim
Received on Sun Jul 16 2000 - 00:00:00 CDT