I have a separate indexed tablespace for all indexed columns averaging about 150 – 200 primary keys columns. I keep getting the ORA-01658: unable to create INITIAL extent for segment in tablespace.

1. Is there any suggestion on ideal sizes for such a large groups of indexes? Please advice on ideal values for the Initial size, Next size, Min size, Increment size by, Minimum number, and Max number?

2. Here is the storage parameters for when creating the Primary key column tablespace LOS_INDEX PCTFREE 10 STORAGE (INITIAL 2864K NEXT 1424K PCTINCREASE 50) - Is the storage parameter for each index too high or what?

Please advice….