Re: newbie plsql

Nuno Martins wrote:
>
> Hi,
>
> i´m tring to write a block in plsql . The ideia is to drop an index and
> 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
Since 7.3
alter index .. rebuild;
will do it for you

Norbert

-- 
=====================================
Norbert Ferstl
DI Forsthuber GmbH
Kohlbauernstr. 17
A-2630 Ternitz, AUSTRIA
Tel: +43 2630 382500
Fax: +43 2630 3825014
<ferstl_at_netway.at>
=====================================