Rem drv: <migrate type="schema_downgrade" version="10.1.0.4"/>
Rem
Rem $Header: user_model_schema_downgrade.sql 19-jul-2005.13:22:01 chyu Exp $
Rem
Rem user_model_schema_downgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      user_model_schema_downgrade.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    chyu        07/19/05 - modifying the new rep manager header 
Rem    scgrover    02/07/05 - scgrover_bug-4169595
Rem    scgrover    02/07/05 - Created
Rem

Rem create new table definition

CREATE TABLE MGMT_USER_CONTEXT_INT
(client_identifier  VARCHAR2(256),
 attribute          NUMBER,
 value              NUMBER,
 CONSTRAINT MGMT_USER_CONTEXT_PK_INT PRIMARY KEY (client_identifier, attribute)
) MONITORING;

Rem redefine the table to be a regular
DECLARE
  no_errors NUMBER := 0;
BEGIN
  BEGIN
    DBMS_REDEFINITION.START_REDEF_TABLE('&&EM_REPOS_USER', 'MGMT_USER_CONTEXT', 'MGMT_USER_CONTEXT_INT');
    DBMS_REDEFINITION.FINISH_REDEF_TABLE('&&EM_REPOS_USER', 'MGMT_USER_CONTEXT', 'MGMT_USER_CONTEXT_INT');
    no_errors := 1;
  EXCEPTION
    WHEN OTHERS THEN
      DBMS_REDEFINITION.ABORT_REDEF_TABLE('&&EM_REPOS_USER', 'MGMT_USER_CONTEXT', 'MGMT_USER_CONTEXT_INT');
  END;

  EXECUTE IMMEDIATE 'DROP TABLE MGMT_USER_CONTEXT_INT';

  IF no_errors = 1 THEN
    EXECUTE IMMEDIATE 'ALTER TABLE MGMT_USER_CONTEXT RENAME CONSTRAINT MGMT_USER_CONTEXT_PK_INT TO MGMT_USER_CONTEXT_PK';
    EXECUTE IMMEDIATE 'ALTER INDEX MGMT_USER_CONTEXT_PK_INT RENAME TO MGMT_USER_CONTEXT_PK';
  END IF;
END;
/