Skip to Content
0
Former Member
Mar 19, 2009 at 03:43 PM

How can I change FREELISTS permanently?

128 Views

I migrated a R/3 4.6C (oracle 9i) from AIX platform to Windows 2003 platform. it's 4.6C with oracle 10g database on Windows platoform. When I apply patch, I always get error of creating tables by SPAM.

Sample:

Retcode 1: error in DDL statement for DB6PMSA

Error 2168-ORA-02168: invalid value for FREELISTS when executing ADD-FIELD of

I have to go to SE14 to maintain storage parameters, set FREELISTS & FREELISTS GROUP as 1, (the previous value is 0). But I don't think I can modify it one by one as there are too many tables I have to change during one patch implementation.

What's wrong? Is there any solution to update FREELISTS & FREELISTS GROUP to 1 as default value and used for other tables creation during patch implementation.

Please advise, and thanks in advance.

James