Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01590: number of segment free list (24) exceeds maximum of 22
From Oracle Docs..
Cause:The value of the storage clause FREELIST GROUPS is greater than the maximum allowed for the block size.
Action:Specify a number for FREELIST GROUPS less than or equal to the maximum when creating the table or index. The block size specified in the initialization parameter DB_BLOCK_SIZE cannot be changed after the database is created.
sorry...
I believe You can pre-create the table/tablespace in the target database with proper storage parameters - Import will use
those..
peter.lee_at_honeywell.com (Plee238) wrote:
>I am doing a full Import. I get this error message when it creates
>table. Since this is an import, I can't change the storage parameter
>of the table in my import. Can someone help me with this problem? If
>I increase the DB_BLOCK_SIZE in my init.ora, will this help?
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Tue Mar 26 2002 - 15:09:28 CST