Example: Change a view name
To change the name of the RD_MEDHIST view to RD_MEDICAL_H:
update RT_MD_VIEWDICTIONARY set viewname='RD_MEDICAL_H' where viewname='RD_MEDHIST';
update RD_DATADICTIONARY set rd_viewname='RD_MEDICAL_H' where rd_viewname='RD_MEDHIST';
commit;