Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie Index Question
The commit shouldn't be necessary for a REBUILD.
Ken
>
> Yes, I rebuild primary key indexes all the time with the REBUILD
> option; you just have to make sure there's enough space in the index
> tablespace for the rebuild.
>
> If you're on UNIX, here's a little script I wrote to rebuild
> an index; it prompts you for the information:
>
> spool rebindx.lst
>
> alter index &iname rebuild
> storage (
> initial &init
> next &next
> maxextents 249 (assumes a 4K database)
> pctincrease 0);
>
> tablespace &tsname;
>
> commit;
>
> spool off
>
> The script is invoked in SQL*Plus by: @rebindx
>
> Take care.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Jun 21 1999 - 07:17:49 CDT