Rem drv: <migrate type="schema_upgrade" version="10.2.0.1" pos="blackout/blackout_schema_upgrade.sql+"/>
Rem
Rem $Header: crypt_schema_upgrade.sql 02-nov-2007.16:57:05 rpinnama Exp $
Rem
Rem crypt_schema_upgrade.sql
Rem
Rem Copyright (c) 2005, 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      crypt_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    rpinnama    12/28/07 - Backport rpinnama_bug-6600690 from main
Rem    kmanicka    07/24/05 - fix new repManager upgrade
Rem    chyu        07/25/05 - modifying the upgrade header 
Rem    kmanicka    07/22/05 - kmanicka_emkey4
Rem    kmanicka    07/15/05 - Created
Rem

DECLARE
  l_repos_time_exists NUMBER := 0;
  l_crypto_seed_exists NUMBER := 0;
BEGIN

  SELECT COUNT(*) INTO l_repos_time_exists
    FROM all_objects
    WHERE owner = '&&EM_REPOS_USER'
    AND object_type = 'TABLE'
    AND object_name = 'MGMT_REPOS_TIME_COEFFICIENT';

  SELECT COUNT(*) INTO l_crypto_seed_exists
    FROM all_objects
   WHERE owner = '&&EM_REPOS_USER'
     AND object_type = 'TABLE'
     AND object_name = 'MGMT_EMCRYPTO_SEED';

    IF ( (l_repos_time_exists = 0) AND (l_crypto_seed_exists > 0) ) THEN

      EXECUTE IMMEDIATE
          'CREATE TABLE MGMT_REPOS_TIME_COEFFICIENT (time_coff)
              AS 
              SELECT seed FROM mgmt_emcrypto_seed ' ;

      EXECUTE IMMEDIATE 'DROP TABLE mgmt_emcrypto_seed ' ;
    END IF;
END ;
/