Batch index reconstruction in Oracle

I. creation process

Create Or Replace ProcedureP_rebuild_all_index
(Tablespace_nameIn Varchar2)
As
SqltVarchar(200);
Begin

ForIdxIn(SelectIndex_name, tablespace_name, statusFromUser_indexesWhereTablespace_name=Tablespace_nameAndStatus='VALID' And Temporary = 'N') Loop
Begin
Sqlt:= 'Alter index' |Idx. index_name| 'Rebuild';
--Dbms_output.put_line (idx. index_name );
--Dbms_output.put_line (sqlt );
EXECUTEIMMEDIATE sqlt;
--After an error occurs, execute the task cyclically.
EXCEPTION
WHENOTHERSTHEN
Dbms_output.put_line (SQLERRM );
End;
EndLoop;
End;

Ii. Test Methods

Declare
-- Tablespace name
Tablespace_name varchar2 (100 );
Begin
Tablespace_name: = 'dddd ';
P_rebuild_all_index (tablespace_name );
End;