Необходимо выполнить в филиалах

/*
select ADR_PRN_CHANGED from RE_objects o
*/
ALTER TRIGGER AER_RE_OBJECTS DISABLE;
ALTER TRIGGER BER_RE_OBJECTS DISABLE;
update RE_objects o set ADR_PRN_CHANGED = 'Д' ;
ALTER TRIGGER AER_RE_OBJECTS ENABLE;
ALTER TRIGGER BER_RE_OBJECTS ENABLE;

ALTER TRIGGER BER_ADR_ADDRESS_VOC DISABLE;
ALTER TRIGGER AER_ADR_ADDRESS_VOC DISABLE;
update adr_address_voc ad set ad.name=substr(ad.name,0,215) where ad.id = 12058006;
update adr_address_voc ad set ad.name=substr(ad.name,0,13) where ad.id = 34055010;
update adr_address_voc ad set ad.name=substr(ad.name,0,13) where ad.id = 41920010;
update adr_address_voc ad set ad.name=substr(ad.name,0,13) where ad.id = 173438001;
update adr_address_voc ad set ad.name=substr(ad.name,0,14) where ad.id = 54995011;
update adr_address_voc ad set ad.name=substr(ad.name,0,18) where ad.id = 215105001;
update adr_address_voc ad set ad.name=substr(ad.name,0,19) where ad.id = 63548011;
update adr_address_voc ad set ad.name=substr(ad.name,0,21) where ad.id = 41947010;
update adr_address_voc ad set ad.name=substr(ad.name,0,22) where ad.id = 237147001;
update adr_address_voc ad set ad.name=substr(ad.name,0,23) where ad.id = 173486001;
update adr_address_voc ad set ad.name=substr(ad.name,0,25) where ad.id = 174477001;
update adr_address_voc ad set ad.name=substr(ad.name,0,27) where ad.id = 172715001;
update adr_address_voc ad set ad.name=substr(ad.name,0,28) where ad.id = 174362001;
update adr_address_voc ad set ad.name=substr(ad.name,0,30) where ad.id = 187976001;
update adr_address_voc ad set ad.name=substr(ad.name,0,32) where ad.id = 52694011;
update adr_address_voc ad set ad.name=substr(ad.name,0,32) where ad.id = 186167001;
update adr_address_voc ad set ad.name=substr(ad.name,0,33) where ad.id = 52704011;
update adr_address_voc ad set ad.name=substr(ad.name,0,39) where ad.id = 48880003;
update adr_address_voc ad set ad.name=substr(ad.name,0,43) where ad.id = 173358001;
update adr_address_voc ad set ad.name=substr(ad.name,0,43) where ad.id = 224311001;
update adr_address_voc ad set ad.name=substr(ad.name,0,44) where ad.id = 246718001;
update adr_address_voc ad set ad.name=substr(ad.name,0,46) where ad.id = 196856001;
update adr_address_voc ad set ad.name=substr(ad.name,0,47) where ad.id = 174446001;
update adr_address_voc ad set ad.name=substr(ad.name,0,48) where ad.id = 172753001;
update adr_address_voc ad set ad.name=substr(ad.name,0,53) where ad.id = 172322001;
update adr_address_voc ad set ad.name=substr(ad.name,0,57) where ad.id = 65640010;
update adr_address_voc ad set ad.name=substr(ad.name,0,57) where ad.id = 219390001;
update adr_address_voc ad set ad.name=substr(ad.name,0,58) where ad.id = 219399001;
update adr_address_voc ad set ad.name=substr(ad.name,0,59) where ad.id = 172741001;
update adr_address_voc ad set ad.name=substr(ad.name,0,60) where ad.id = 171967001;
update adr_address_voc ad set ad.name=substr(ad.name,0,62) where ad.id = 56074011;
update adr_address_voc ad set ad.name=substr(ad.name,0,63) where ad.id = 48805003;
update adr_address_voc ad set ad.name=substr(ad.name,0,63) where ad.id = 203077001;
update adr_address_voc ad set ad.name=substr(ad.name,0,80) where ad.id = 146384001;
update adr_address_voc ad set ad.name=substr(ad.name,0,82) where ad.id = 41470011;
update adr_address_voc ad set ad.name=substr(ad.name,0,82) where ad.id = 67951010;
update adr_address_voc ad set ad.name=substr(ad.name,0,88) where ad.id = 210090001;
update adr_address_voc ad set ad.name=substr(ad.name,0,89) where ad.id = 169031001;
update adr_address_voc ad set ad.name=substr(ad.name,0,110) where ad.id = 163092001;
update adr_address_voc ad set ad.name=substr(ad.name,0,119) where ad.id = 165101001;
update adr_address_voc ad set ad.name=substr(ad.name,0,133) where ad.id = 42538011;
update adr_address_voc ad set ad.name=substr(ad.name,0,138) where ad.id = 174239001;
update adr_address_voc ad set ad.name=substr(ad.name,0,138) where ad.id = 237097001;
update adr_address_voc ad set ad.name=substr(ad.name,0,153) where ad.id = 250430001;
update adr_address_voc ad set ad.name=substr(ad.name,0,156) where ad.id = 194864001;
update adr_address_voc ad set ad.name=substr(ad.name,0,164) where ad.id = 49236003;
update adr_address_voc ad set ad.name=substr(ad.name,0,170) where ad.id = 91466002;
update adr_address_voc ad set ad.name=substr(ad.name,0,179) where ad.id = 183804001;
update adr_address_voc ad set ad.name=substr(ad.name,0,189) where ad.id = 134250001;
update adr_address_voc ad set ad.name=substr(ad.name,0,198) where ad.id = 239469001;
update adr_address_voc ad set ad.name=substr(ad.name,0,198) where ad.id = 240335001;
update adr_address_voc ad set ad.name=substr(ad.name,0,201) where ad.id = 75656011;
update adr_address_voc ad set ad.name=substr(ad.name,0,202) where ad.id = 189157001;
update adr_address_voc ad set ad.name=substr(ad.name,0,207) where ad.id = 173393001;
update adr_address_voc ad set ad.name=substr(ad.name,0,213) where ad.id = 41066011;
update adr_address_voc ad set ad.name=substr(ad.name,0,213) where ad.id = 165692001;
update adr_address_voc ad set ad.name=substr(ad.name,0,215) where ad.id = 48796003;
update adr_address_voc ad set ad.name=substr(ad.name,0,215) where ad.id = 48799003;
update adr_address_voc ad set ad.name=substr(ad.name,0,216) where ad.id = 49445002;
update adr_address_voc ad set ad.name=substr(ad.name,0,216) where ad.id = 89054002;
update adr_address_voc ad set ad.name=substr(ad.name,0,230) where ad.id = 242588001;

update adr_address_voc ad set ad.name='14-2-1' where ad.id = 42668009;
update adr_address_voc ad set ad.name='4-2-1' where ad.id = 42666009;
update adr_address_voc ad set ad.name='2-1-1' where ad.id = 42665009;
update adr_address_voc ad set ad.name='1-9-3б,1-9-5,1-15' where ad.id = 42664009;
update adr_address_voc ad set ad.name='42-43-73' where ad.id = 42663009;

update adr_address_voc ad set ad.name='оп149 - ТП-26-29-15,оп153 - оп153-4' where ad.id = 42898010;
update adr_address_voc ad set ad.name='оп125-4 - оп125-4-8км,оп148 - ТП-26-29-14' where ad.id = 42897010;
update adr_address_voc ad set ad.name='оп125 - ТП-15-10 (лн01),оп125 - ТП-26-29-19 (лн02)' where ad.id = 42896010;
update adr_address_voc ad set ad.name='ЗРУ-10кВ ПС"КСК" - оп35 с отп.оп26 - оп26-1км,оп110 - ТП-05' where ad.id = 42895010;

update adr_address_voc ad set ad.name='оп5 - оп19' where ad.id = 42713009;
update adr_address_voc ad set ad.name='оп4-1-1 - оп4-1-7' where ad.id = 42712009;
update adr_address_voc ad set ad.name='оп4-10 - оп4-13' where ad.id = 42711009;
update adr_address_voc ad set ad.name='оп4-8-2' where ad.id = 42708009;
update adr_address_voc ad set ad.name='оп4-1 - оп4-9' where ad.id = 42707009;
update adr_address_voc ad set ad.name='ТП 42-43-21 - оп4' where ad.id = 42706009;

ALTER TRIGGER BER_ADR_ADDRESS_VOC ENABLE;
ALTER TRIGGER AER_ADR_ADDRESS_VOC ENABLE;
commit;

после прогрузки

select * from cg_parameters cp where cp.name='MODE'; 
update cg_par_values cpv set cpv.value='Р' where cpv.cg_par_id = 8000;