newbie plsql
From: Nuno Martins <nunomartins_at_mail.telepac.pt>
Date: 1997/10/07
Message-ID: <343A9DE7.EAABED6_at_mail.telepac.pt>#1/1
Date: 1997/10/07
Message-ID: <343A9DE7.EAABED6_at_mail.telepac.pt>#1/1
Hi,
[Quoted] [Quoted] i´m tring to write a block in plsql . The ideia is to drop an index and [Quoted] re-create the same index again ( desfragmentation ) . But i have a problem after i drop the index , i don´t know how to commit, and the create index fails because it thas not have space ( the create index allocates the same extents that the index had ) .
begin
....
dbms_sql.parse(cursor,'drop index ISALES',0);
i:=dbms_sql.execute(cursor);
dbms_sql.close_cursor(cursor);
commit;
dbms_sql.parse(cursor,'create index ISALES on SALES (......) ... ',0);
i:=dbms_sql.execute(cursor);
dbms_sql.close_cursor(cursor);
...
end;
Have you ever had the same problem ?
Nuno
PORTUGAL
Received on Tue Oct 07 1997 - 00:00:00 CEST