Rem drv: <migrate type="data_upgrade" version="10.2.0.1"/>
Rem
Rem $Header: collections_data_upgrade.sql 13-sep-2005.02:57:14 rkpandey Exp $
Rem
Rem collections_data_upgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      collections_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    rkpandey    09/13/05 - Add collections_common_init.sql 
Rem    jsadras     08/31/05 - add bulk batch param 
Rem    jsadras     08/19/05 - change add_metaver_upd_callback to 
Rem                           add_metaver_catprop_callback 
Rem    jsadras     07/26/05 - handle meta ver change for def collections 
Rem    chyu        07/18/05 - adding the upgrade header 
Rem    scgrover    07/15/05 - scgrover_add_dbms_job_extended_sql_trace
Rem    scgrover    07/08/05 - Created
Rem

BEGIN
  INSERT INTO MGMT_PARAMETERS
    (parameter_name, parameter_value, parameter_comment)
  VALUES
    ('EST_WORKER1', 'OFF', 'Extended SQL trace for EM_TASK.WORKER(1) dbms jobs. ' ||
                           'Use EM_TASK.DBMSJOB_EXTENDED_SQL_TRACE_ON(boolean, 1) to alter');

  COMMIT;
EXCEPTION
  WHEN OTHERS THEN
    UPDATE MGMT_PARAMETERS SET parameter_value = 'OFF' WHERE parameter_name = 'EST_WORKER1';
    COMMIT;
END;
/

BEGIN
  INSERT INTO MGMT_PARAMETERS
    (parameter_name, parameter_value, parameter_comment)
  VALUES
    ('EST_WORKER2', 'OFF', 'Extended SQL trace for EM_TASK.WORKER(2) dbms jobs. ' ||
                           'Use EM_TASK.DBMSJOB_EXTENDED_SQL_TRACE_ON(boolean, 2) to alter');

  COMMIT;
EXCEPTION
  WHEN OTHERS THEN
    UPDATE MGMT_PARAMETERS SET parameter_value = 'OFF' WHERE parameter_name = 'EST_WORKER2';
    COMMIT;
END;
/

BEGIN
  mgmt_collection.set_bulk_batch_size(5000) ;
  COMMIT ;
END ;
/

-- Add target meta ver update callback to start default collections for new version
BEGIN
  MGMT_TARGET.add_metaver_catprop_callback(
    p_callback_name => 'EM_COLL_UTIL.handle_metaver_change_def_coll',
    p_target_type => ' ');
EXCEPTION
WHEN OTHERS THEN
  IF sqlerrm NOT LIKE '%callback%already%exist%'
  THEN 
    RAISE ;
  END IF ; 
END;
/

@@&&EM_SQL_ROOT/core/v102020/collections/collections_common_init.sql