Re: What to do when"index made unusable by..." on loading of large table?

1. get your application indexes out of your SYSTEM tablespace. Create a different tablespace(s) for your application data and indexes. If SYSTEM runs out of space you could end up in REAL trouble. Also create a temporary tablespace for sort/work, and assign this to the userid that is doing the loading.

ie ALTER USER XXXX TEMPORARY TABLESPACE TEMPWORK

                   DEFAULT TABLESPACE USERDATA

2) if you are loading tons of data you might consider dropping all your indexes, loading the data, then rebuilding the indexes.

-- 
Wayne Linton
lintonw_at_cadvision.com