Problems building SQLTEXT indexes (Suggestions)

From: Joel Fedorko <jfedorko_at_ncsa.uiuc.edu>
Date: Thu, 14 Jan 1993 22:43:18 GMT
Message-ID: <1993Jan14.224318.22020_at_ncsa.uiuc.edu>


I've been attempting to build a large location list table (18m+rows) and I'm getting a - ORA-00054: resource busy and acquire with NOWAIT specified - when I hit around row 6.3million, I've built a 12m row version of this before and I'm running 1gig+ rollback segments and temporary tablespaces. Any suggestions?

Thanks. -Joel

-- 
Joel Fedorko                         Remember Bit Hopper, 
Consultant                     You must become one with the machine.
Day Data 
jfedorko_at_ncsa.uiuc.edu        Any opinions I express will be ignored.
Received on Thu Jan 14 1993 - 23:43:18 CET

Original text of this message