Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\db\v102010\reports\db_outofbox_elements.sql
Rem drv: <migrate type="data_upgrade" version="10.2.0.0" pos="reports/overview_outofbox.sql+" condition="EM_REPOS_MODE=CENTRAL"/> Rem Rem $Header: db_outofbox_elements.sql 28-nov-2006.06:33:54 mnihalan Exp $ Rem Rem db_outofbox_elements.sql Rem Rem Copyright (c) 2004, 2006, Oracle. All rights reserved. Rem Rem NAME Rem db_outofbox_elements.sql - <one-line expansion of the name> Rem Rem DESCRIPTION Rem <short description of component this file declares/defines> Rem Rem NOTES Rem !!!!!! Please update upgrade script if updates are made. !!!!!!! Rem Rem MODIFIED (MM/DD/YY) Rem mnihalan 11/28/06 - Fix bug 5683385 Rem rreilly 07/15/05 - bug 4494270 make this dir match beta Rem chyu 07/12/05 - adding the new rep manager upgrade header Rem rreilly 05/03/05 - add group elements Rem rreilly 04/28/05 - add cumulative target type Rem rreilly 04/11/05 - add new generic elems for db reports Rem qsong 11/12/04 - qsong_asm_reports Rem mnihalan 10/07/04 - Created Rem SET DEFINE OFF DECLARE l_target_types MGMT_IP_TARGET_TYPES; l_param_classes MGMT_IP_PARAM_CLASSES; BEGIN -- ------------------------------------------------------------------------- -- Element Definitions -- ------------------------------------------------------------------------- -- Element that connects to the target l_param_classes := MGMT_IP_PARAM_CLASSES(); l_param_classes.extend(2); l_param_classes(1) := 'oracle.sysman.eml.ip.render.elem.HeaderParamController'; l_param_classes(2) := 'oracle.sysman.eml.ip.render.elem.SQLStatementParamController'; mgmt_ip.add_element_definition ('target_user_table_from_sql', 'database_target_type', 'target_user_table_from_sql', 'oracle.sysman.db.util.reports.TableTargetRenderController', 0, l_param_classes, null); COMMIT; -- ---------------------------------------- -- Create Generic Database Element Type -- -- NOTE: Element SQL will be required to -- exclude RAC Instances. -- Ideally this would return only Databases, -- but since there is no way to pass in -- category props, this element type will -- return all instances and rac dbs -- ---------------------------------------- l_target_types := MGMT_IP_TARGET_TYPES(); l_target_types.extend(2); l_target_types(1) := 'oracle_database'; l_target_types(2) := 'rac_database'; mgmt_ip.add_element_type ( p_element_type_nlsid => 'DBMSG_DBINSTANCE_RAC_TARGET_TYPE', p_target_types => l_target_types); -- ---------------------------------------- -- Create Generic Table Elements -- ---------------------------------------- -- -- User Element: DBMSG_USER_TABLE_FROM_SQL_ELEM -- User can see the SQL -- mgmt_ip.add_table_from_sql_elem_def ( p_element_name_nlsid => 'DBMSG_USER_TABLE_FROM_SQL_ELEM', p_element_type_nlsid => 'DBMSG_DBINSTANCE_RAC_TARGET_TYPE', p_description_nlsid => 'DBMSG_USER_TABLE_FROM_SQL_DESC', p_internal_use_only => 1, p_query_views => 1); -- -- Internal Element: DBMSG_TABLE_FROM_SQL_ELEM -- User can't see the SQL -- mgmt_ip.add_table_from_sql_elem_def ( p_element_name_nlsid => 'DBMSG_TABLE_FROM_SQL_ELEM', p_element_type_nlsid => 'DBMSG_DBINSTANCE_RAC_TARGET_TYPE', p_description_nlsid => 'DBMSG_TABLE_FROM_SQL_DESC', p_internal_use_only => 1, p_query_views => 0); -- ---------------------------------------- -- Create Generic Chart Elements -- ---------------------------------------- -- -- User Element: DBMSG_USER_CHART_FROM_SQL_ELEM -- User can see the SQL -- mgmt_ip.add_chart_from_sql_elem_def ( p_element_name_nlsid => 'DBMSG_USER_CHART_FROM_SQL_ELEM', p_element_type_nlsid => 'DBMSG_DBINSTANCE_RAC_TARGET_TYPE', p_description_nlsid => 'DBMSG_USER_CHART_FROM_SQL_DESC', p_internal_use_only => 1, p_query_views => 1); END; / SET DEFINE ON
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de