Re: oracle error 1658

Another possibility might be that the extent size is larger than what the datafiles are that were created.
For example, if the initial extent size -- even if compressed -- is, say 5 GB, and your datafiles for the tablespace are set up as 2GB (however many), you won't be able to import w/o creating a larger datafile for the initial extent, or creating the table first and importing with ignore=Y. Extents can't span datafiles.

hth

Nevin Hahn wrote:

> Hi,
>
> Did you compress extents when exporting? If so you may have created a giant
> extent that may not
> exist as contiguous space in the user_data tablespace. Even if you did not
> compress extents on the
> export, it sounds like you will run out of space and therefore need to add a
> datafile to the tablespace.
>
> Nevin Hahn
> nhahn_at_evoke.com
>
> <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.
Received on Tue Sep 12 2000 - 17:33:25 CDT