INDEX CREATE
Date: Thu, 15 Jul 1999 11:25:40 -0400
Message-ID: <96936058_at_NEWS.SAIC.COM>
Hi...
[Quoted] [Quoted] I have a question...and need you all help promptly....
[Quoted] I have one PL/SQL script to run for a table. The table has an UNIQUE INDEX [Quoted] [Quoted] (col1 + col2 + col3). Now I would like create an NON-UNIQUE INDEX (col1 + [Quoted] [Quoted] col2 + col3) and I got the following error...
ORA-00054: resource busy and acquire with NOWAIT specified
I need the NON-UNIQUE INDEX to run the PL/SQL more sufficient and faster.....But without the UNIQUE INDEX it is tremendously slow....Any thoughts to solve the problem??? The following is my PL/SQL script
DECLARE
CURSOR memory is
select distinct
col1, col2 col3 from my_table;
--EXECUTABLE SECTION
BEGIN
FOR i in memory LOOP
delete from my_table where col1 = i.col1 and col2 = i.col2 and col2 = i.col3; insert into my_table (col1,col2,col3) values (i.col1,i.col2,i.col3);
END LOOP;
COMMIT;
END;
/
Received on Thu Jul 15 1999 - 17:25:40 CEST