Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What to do when"index made unusable by..." on loading of large table?
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.comReceived on Wed Nov 26 1997 - 00:00:00 CST