drop index apps_desc_idx;
drop index apptempl_desc_idx;
drop index js_packs_desc_idx;
drop index reports_desc_idx;

update APPS set DESCRIPTION = substr(DESCRIPTION, 1, 512);
update APPTEMPLATES set DESCRIPTION = substr(DESCRIPTION, 1, 512);
update JS_PACKS set P_DESC = substr(P_DESC, 1, 512);
update REPORT_TEMPLATES set DESCRIPTION = substr(DESCRIPTION, 1, 512);

alter table APPS modify DESCRIPTION varchar2(512);
alter table APPTEMPLATES modify DESCRIPTION varchar2(512);
alter table JS_PACKS modify P_DESC varchar2(512);
alter table REPORT_TEMPLATES modify DESCRIPTION varchar2(512);

create index apps_desc_idx on APPS (DESCRIPTION);
create index apptempl_desc_idx on APPTEMPLATES (DESCRIPTION);
create index js_packs_desc_idx on JS_PACKS (P_DESC);
create index reports_desc_idx on REPORT_TEMPLATES (DESCRIPTION);