Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: newbie plsql
Did you try the coalesce the tablespace ?
Nuno Martins wrote in message <343A9DE7.EAABED6_at_mail.telepac.pt>...
>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
>
Received on Thu Oct 09 1997 - 00:00:00 CDT