Re: oracle error 1658

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 12 Sep 2000 22:35:27 +0200
Message-ID: <968825656.722.1.pluto.d4ee154e@news.demon.nl>

<marima_at_my-deja.com> wrote in message news:8pm2qe$bjg$1_at_nnrp1.deja.com...
> i am importing tables and i get error 1658
> unable to create initial extent for segment in tablespace user_data
> how do i fix this
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

This means either:
there's insuffficient space
or
there's sufficient space but non-contiguous.

To resolve it:
pre-create the object with a smaller initial extent (you did use compress=y in the export didn't you? This is one of the most common problems with compress=y, reason why many people don't use it), or enlarge the tablespace user_data.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Sep 12 2000 - 15:35:27 CDT