Rem drv: <migrate type="schema_upgrade" version="11.2.0.0"/>
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/11.2.0.0/rec/rec_schema_upgrade.sql /st_emdbsa_11.2/1 2009/01/27 16:16:51 mmootha Exp $
Rem
Rem rec_schema_upgrade.sql
Rem
Rem Copyright (c) 2007, 2008, Oracle and/or its affiliates.
Rem All rights reserved. 
Rem
Rem    NAME
Rem      rec_schema_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    mmootha     10/10/08 - 10.2.0.5GC to 11.2DB code slap.
Rem    pbantis     08/27/08 - Bug 7355213 emuser col.
Rem    xshi        03/08/07 - recovery catalog upgrade - vpc
Rem    xshi        03/08/07 - Created
Rem

ALTER TABLE MGMT_RCVCAT_CONFIG
ADD (VPCBASE_GUID RAW(16),
     EM_USER VARCHAR2(256));

ALTER TABLE MGMT_RCVCAT_CONFIG
DROP UNIQUE(RCVCAT_GUID);

ALTER TABLE MGMT_RCVCAT_CONFIG
ADD (CONSTRAINT MGMT_RCVCAT_CONFIG_UQ
     UNIQUE(RCVCAT_GUID, EM_USER));

Rem ALTER TABLE mgmt_rcvcat_config
Rem ADD ( CONSTRAINT vpcbase_guid_fk 
Rem      FOREIGN KEY (vpcbase_guid)
Rem      REFERENCES mgmt_rcvcat_config (rcvcat_guid));

ALTER TABLE MGMT_RCVCAT_REPOS
ADD (EM_USER VARCHAR2(256));

ALTER TABLE MGMT_RCVCAT_REPOS
DROP UNIQUE(TARGET_GUID);

ALTER TABLE MGMT_RCVCAT_REPOS
ADD (CONSTRAINT MGMT_RCVCAT_REPOS_UQ
     UNIQUE(TARGET_GUID, EM_USER));