Re: Rebuild implicit index for primary key

Jim Smith:

> ...
> Or you could use an anonymous PL/SQL block
>
> declare
> sqlstmt varchar2(1000);
> begin
> SELECT
> 'ALTER INDEX '||OWNER||'.'||INDEX_NAME||' REBUILD;'
> into sqlstmt
> FROM
> DBA_INDEXES
> WHERE
> STATUS='INVALID'
> AND OWNER='owner_name_here'
> AND TABLE_NAME='table_name_here';
>
> execute immediate sqlstmt;
>
> end;
>
> (with appropriate error checking of course)

Perfect. That's exactly what I was looking for. Thank you very much.

Franz Received on Sat Jan 06 2007 - 11:07:44 CST