The use of bind variables in Reports often gives the following error; SQL Error: Missing IN or OUT parameter at index:: 1

The way round this is to simply change the ":" to "&"

The following code when used in a Report will prompt for a schema owner and table search string.

select 'alter index ' || OWNER || '.' || INDEX_NAME || ' nomonitoring usage;'

from dba_indexes

where owner = &OWNER

and TABLE_NAME like &TABLE_NAME

Enter strings enclosed by single quotes to obtain indexes owned by the schema name (e.g. 'EMP' and '%')