REBUILD INDICES

select  'ALTER INDEX HR.' || index_name || ' REBUILD;' from dba_indexes

where owner='HR'

and table_name='EMPLOYEES'

SELECT owner,table_name,num_rows from dba_tables where owner='HR'