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>
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