Execute Immediate error !!

[pss]

Execute this:

select owner, index_name
from dba_indexes
where table_owner='MDM3'
and table_name = 'T_OLD_CMPN_HIST_XTRCT';

See if any indexes on this table are created in a different schema (other than MDM3).