Re: unable to create INITIAL extent for segmentintablespace

Assuming the obvious that the tablespace size is still the same prior to the upgrade to Win2000, it appears that what has happenned is the export that you have done was set to compress the extents of the objects into one large initial extent. This is the default behavior of export. There are several way around this.

The first, which I doubt you can do, would be to re-export the database setting COMPRESS=N.

Another option is on the import command. You can build a SQL script of the tables and indexes by issuing the IMP INDEXFILE=filename.sql. This will create a script of the tables and indexes that you can resize and pre-create them in the database. Then you can import using the IGNORE=Y option.

Hope this helps.
Dave

Kim Ammouche wrote:

> 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