Re: FREELIST GROUPS - ORA-1590 - What the heck...

Brian,

You can find out all about FREELIST GROUPS if you look in the SQL Language ref manual under "STORAGE CLAUSE"

As for the problem at hand -- first of all, you only need to worry about this param if you are using parallel server. The fact that you are having a problem hints that perhaps the block size on the destination db is smaller than the block size on the source db -- but I am not possitive about that -- I know that the value of FREELISTS is a function of block size though.

If all else fails, try pre-creating your tables and then doing the import w/ ignore=Y.

Regards,
Charles_Dye_at_krinfo.com

In article <Drpsvp.4vE_at_falcon.daytonoh.attgis.com>, brian.sakach_at_daytonoh.attgis.com (Brian Sakach) writes:
> I never heard of FREELIST GROUPS and I can't find any information
> in the books. I'm on 7.2.2 on an Unix box. I did an export and upon
> importing I got the error. Can anyone shed some light on this?
>
> > oerr ora 1590
> 01590, 00000, "number of segment free list (%s) exceeds maximum of %s"
> // *Cause: storage parameter FREELIST GROUPS is too large.
> // *Action: Reduce storage parameters FREELIST GROUPS

-- 
Chas. Dye
Oracle Database Administrator
Charles_Dye_at_krinfo.com