ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEFA79D2E0530100007F1FF2 Blitz Report Category Y select xrcv.category value, (select count(*) from xxen_report_category_assigns xrca where xrcv.category_id=xrca.category_id) description from xxen_report_categories_v xrcv order by xrcv.category US B04763D730F050D7E0530100007F06B3 Blitz Report Name (wildcard) select xrv.report_name value, xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null)||substrb(xrv.description,1,4000-lengthb(xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null))) description from xxen_reports_v xrv order by xrv.report_name US 9FD1E69E877F1D9DE0530100007F19D3 DBA Database Link Y select lower(substr(ddl.db_link,1,instr(ddl.db_link,'.')-1)) value, ddl.username||'@'||ddl.host description from dba_db_links ddl order by value US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 9FD333C68A3E2A53E0530100007F15ED select case when x.report_name is not null and x.updated_remote='Y' and (x.name_diff='Y' or x.descr_diff='Y' or x.sql_diff='Y') then 'conflict' when x.report_name is null and x.report_name_remote is not null then 'add to local database' when x.report_name is not null and x.report_name_remote is null then 'transfer' when x.name_diff='Y' or x.descr_diff='Y' or x.sql_diff='Y' then 'update' end result, x.* from ( select (select 'Y' from fnd_user@&database_link fu where xrv2.last_updated_by=fu.user_id and fu.user_name not in ('ANONYMOUS','ENGINATICS')) updated_remote, case when xrv.report_name<>xrv2.report_name then 'Y' end name_diff, case when xrv.guid<>xrv2.guid then 'Y' end guid_diff, case when xrv.sql_text_short<>xrv2.sql_text_short or xrv.sql_length<>xrv2.sql_length then 'Y' end sql_diff, case when xrv.description<>xrv2.description then 'Y' end descr_diff, case when xrv.report_name is not null and xrv2.report_name is not null and nvl(xrv.category,'x')<>nvl(xrv2.category,'x') then 'Y' end category_diff, xrv.type_dsp type, xrv.category, xrv2.type_dsp type_remote, xrv2.category category_remote, xrv.report_name, xrv2.report_name report_name_remote, xrv.description, xrv2.description description_remote, (select count(*) from xxen_report_parameters xrp where xrv.report_id=xrp.report_id) parameter_count, (select count(*) from xxen_report_parameters@&database_link xrp where xrv2.report_id=xrp.report_id) parameter_count_remote, xxen_util.user_name(xrv.last_updated_by) last_updated_by, xrv.last_update_date, xxen_util.user_name@&database_link(xrv2.last_updated_by) last_updated_by_remote, xrv2.last_update_date last_update_date_remote, xxen_util.user_name(xrv.created_by) created_by, xrv.creation_date, xxen_util.user_name@&database_link(xrv2.created_by) created_by_remote, xrv2.creation_date creation_date_remote, xrv.sql_text_short sql_text, xrv2.sql_text_short sql_text_remote from (select xrv.*, dbms_lob.substr(xrv.sql_text,4000,1) sql_text_short from xxen_reports_v xrv where 1=1) xrv full join (select xrv.* from xxen_reports_v_@&database_link xrv where 1=1) xrv2 on xrv.guid=xrv2.guid or xrv.report_name=xrv2.report_name ) x where 2=2 order by coalesce(x.name_diff,x.descr_diff,x.sql_diff), x.last_update_date_remote desc nulls last, x.last_update_date desc Y AR Compare Blitz Reports between environments يتطلب العرض التالي ليتم إنشاؤه في البيئة البعيدة لتجنب ORA-64202: تمت مصادفة محدد LOB المؤقت أو المجرد البعيد إنشاء أو استبدال عرض xxen_reports_v_ as تحديد xrv. * ، dbms_lob.substr (xrv.sql_text_full، 4000،1) sql_text_short من xxen_reports_v xrv ؛ D Compare Blitz Reports between environments Erfordert, dass die folgende Ansicht in der entfernten Umgebung erstellt wird, um ORA-64202: entfernter temporärer oder abstrakter LOB-Locator wurde angetroffen create or replace view xxen_reports_v_ as select xrv.*, dbms_lob.substr(xrv.sql_text_full,4000,1) sql_text_short from xxen_Berichte_v xrv; E Compare Blitz Reports between environments Requiere que se cree la siguiente vista en el entorno remoto para evitar ORA-64202: se encuentra un localizador LOB remoto temporal o abstracto crear o sustituir la vista xxen_reports_v_ como seleccionar xrv.*, dbms_lob.substr(xrv.sql_text_full,4000,1) sql_text_short de xxen_reports_v xrv; F Compare Blitz Reports between environments Nécessite la création de la vue suivante sur l'environnement distant pour éviter l'ORA-64202 : le localisateur de LPP temporaire ou abstrait distant est rencontré créer ou remplacer la vue xxen_reports_v_ comme sélectionnez xrv.*, dbms_lob.substr(xrv.sql_text_full,4000,1) sql_text_short à partir de xxen_reports_v xrv ; I Compare Blitz Reports between environments Richiede che la seguente vista sia creata nell'ambiente remoto per evitare ORA-64202: si incontra un localizzatore LOB temporaneo o astratto remoto creare o sostituire la vista xxen_reports_v_ come selezionare xrv.*, dbms_lob.substr(xrv.sql_text_full,4000,1) sql_text_short da xxen_reports_v xrv; JA Compare Blitz Reports between environments ORA-64202: リモートの一時的または抽象的な LOB ロケータが発生しました。 ビュー xxen_reports_v_ を次のように作成または置換します。 選り分ける xrv.*. dbms_lob.substr(xrv.sql_text_full,4000,1) sql_text_short から xxen_reports_v xrv. KO Compare Blitz Reports between environments ORA-64202를 방지하려면 원격 환경에서 다음 뷰를 만들어야합니다. 원격 임시 또는 추상 LOB 로케이터가 발견되었습니다. 보기 xxen_reports_v_를 다음과 같이 생성 또는 교체 고르다 xrv. *, dbms_lob.substr (xrv.sql_text_full, 4000,1) sql_text_short ...에서 xxen_reports_v xrv; PTB Compare Blitz Reports between environments Requer a seguinte visão a ser criada no ambiente remoto para evitar ORA-64202: localizador remoto temporário ou abstrato LOB é encontrado criar ou substituir a view xxen_reports_v_ como selecione xrv.*, dbms_lob.substr(xrv.sql_text_full,4000,1) sql_text_short de xxen_reports_v xrv; RU Compare Blitz Reports between environments Чтобы избежать ORA-64202, необходимо создать в удаленной среде следующий вид: удаленный временный или абстрактный локатор LOB. создать или заменить вид xxen_reports_v_ как выбрать xrv.* dbms_lob.substr(xrv.sql_text_full,4000,1) sql_text_short с xxen_reports_v xrv; S Compare Blitz Reports between environments Kräver att följande vy skapas i fjärrmiljön för att undvika ORA-64202: fjärrfällig eller abstrakt LOB-lokaliserare påträffas skapa eller ersätt vyn xxen_reports_v_ som Välj xrv. *, dbms_lob.substr (xrv.sql_text_full, 4000,1) sql_text_short från xxen_reports_v xrv; TR Compare Blitz Reports between environments ORA-64202'yi önlemek için uzak ortamda aşağıdaki görünümün oluşturulmasını gerektirir: uzak geçici veya soyut LOB bulucu ile karşılaşıldı xxen_reports_v_ görünümünü oluştur veya değiştir seç xrv. *, dbms_lob.substr (xrv.sql_text_full, 4000,1) sql_text_short itibaren xxen_reports_v xrv; US Blitz Report Comparison between environments Shows Blitz Report differences between the local and a remote database server. Requires following view to be created on the remote environment to avoid ORA-64202: remote temporary or abstract LOB locator is encountered create or replace view xxen_reports_v_ as select xrv.*, dbms_lob.substr(xxen_util.clob_substrb(xrv.sql_text_full,4000,1)) sql_text_short from xxen_reports_v xrv; ZHS Compare Blitz Reports between environments 需要在远程环境中创建以下视图，以避免遇到ORA-64202：远程临时或抽象LOB定位器。 创建或替换视图xxen_reports_v_为 挑选 xrv.*, dbms_lob.substr(xrv.sql_text_full,4000,1) sql_text_short。 从 xxen_reports_v xrv; Enginatics &database_link 1=1 2=2 1 10 &database_link <parameter_value> LOV DBA Database Link 9FD1E69E877F1D9DE0530100007F19D3 Y select lower(substr(ddl.db_link,1,instr(ddl.db_link,'.')-1)) value, ddl.username||'@'||ddl.host description from dba_db_links ddl order by value r1224a Y F Base de données distante US Remote Database 2 20 1=1 regexp_like(xrv.category,'(^|, )'||:category||'(, |$)') LOV Blitz Report Category 8E2FF36EDEFA79D2E0530100007F1FF2 Y select xrcv.category value, (select count(*) from xxen_report_category_assigns xrca where xrcv.category_id=xrca.category_id) description from xxen_report_categories_v xrcv order by xrcv.category Discoverer US Category 3 30 1=1 xrv.report_name like :report_name_like LOV Blitz Report Name (wildcard) B04763D730F050D7E0530100007F06B3 select xrv.report_name value, xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null)||substrb(xrv.description,1,4000-lengthb(xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null))) description from xxen_reports_v xrv order by xrv.report_name US Report Name like 4 40 2=2 ( nvl(x.report_name,'x')<>nvl(x.report_name_remote,'x') or x.parameter_count<>x.parameter_count_remote or x.name_diff='Y' or x.sql_diff='Y' or x.descr_diff='Y' or x.category_diff='Y' ) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show Differences only