Rem drv: <migrate type="data_upgrade" version="11.2.0.0"/>
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/11.2.0.0/dv/dv_data_upgrade.sql /st_emdbsa_11.2/1 2009/02/12 23:34:29 hpalitan Exp $
Rem
Rem dv_data_upgrade.sql
Rem
Rem Copyright (c) 2008, 2009, Oracle and/or its affiliates.
Rem All rights reserved. 
Rem
Rem    NAME
Rem      dv_data_upgrade.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    amahalin    12/02/08 - To add commit
Rem    amahalin    11/20/08 - To make the DVA URL property hidden
Rem    sudvarma    08/22/08 - 
Rem    amahalin    08/07/08 - To include DV URL property
Rem    sudvarma    07/21/08 - To register dv related job commands
Rem    sudvarma    07/21/08 - Created
Rem

SET ECHO ON
SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100

DECLARE 
 target_type_list SMP_EMD_STRING_ARRAY;

BEGIN
    target_type_list := SMP_EMD_STRING_ARRAY();
    target_type_list.extend(2);
    target_type_list(1):='oracle_database';
    target_type_list(2):='rac_database';   

MGMT_PROPERTIES.add_sys_target_property(p_property_name => 'DatabaseVaultAdmin_URL',p_target_type_list =>
target_type_list,p_property_display_name => 'Database Vault Administrator URL',p_property_display_nlsid => 'database_vault_URL',
p_default_value => NULL,p_computed_flag => 0,p_credential_flag => 0,p_required_flag => 0,p_read_only_flag => 0,
p_hidden_flag => 1);
-- value 1 for last param is to make this property Hidden
COMMIT;
END;
/