
Rem BEGIN EMRU_FILE_METADATA
Rem EMRU_SOURCE_FILE:emcore/source/oracle/sysman/emdrep/sql/emregistry/latest/emregistry.sql
Rem EMRU_UNIX_DELIVERABLES:
Rem emcore/source/oracle/sysman/emdrep/sql/emregistry/latest/emregistry.sql

Rem EMRU_FILE_POSTINSTALL:<!!! enter the view based location of the executable file. If there is NONE leave as-is !!!>
Rem EMRU_GENERIC_FLAG:NONE
Rem END EMRU_FILE_METADATA

Rem drv: <create type="editioning_views" />

create or replace editioning view EM_REGISTRATION as select * from EM_REGISTRATION_E;

create or replace editioning view EM_REGISTRY_DLFFILES as select * from EM_REGISTRY_DLFFILES_E;

create or replace editioning view MGMT_COMPS_TOPURGE as select * from MGMT_COMPS_TOPURGE_E;

create or replace editioning view MGMT_EMDEP_LOGS as select * from MGMT_EMDEP_LOGS_E;

create or replace editioning view MGMT_EMPREREQKIT_PROPS as select * from MGMT_EMPREREQKIT_PROPS_E;

create or replace editioning view MGMT_PLUGIN_COMP_INFO as select * from MGMT_PLUGIN_COMP_INFO_E;

create or replace editioning view MGMT_PLUGIN_DEP_CERT_INFO as select * from MGMT_PLUGIN_DEP_CERT_INFO_E;

create or replace editioning view MGMT_UPGRADEUTIL_COMP as select * from MGMT_UPGRADEUTIL_COMP_E;

create or replace editioning view MGMT_UPGRADEUTIL_PARAM as select * from MGMT_UPGRADEUTIL_PARAM_E;

create or replace editioning view MGMT_UPGRADEUTIL_PREUPG_REG as select * from MGMT_UPGRADEUTIL_PREUPG_REG_E;

create or replace editioning view MGMT_UPGRADEUTIL_PROPS as select * from MGMT_UPGRADEUTIL_PROPS_E;

create or replace editioning view MGMT_UPGRADEUTIL_TASK as select * from MGMT_UPGRADEUTIL_TASK_E;

create or replace editioning view EM_PATCH_REGISTRY as select * from EM_PATCH_REGISTRY_E;

create or replace editioning view EM_PATCH_COMPATABILITY as select * from EM_PATCH_COMPATABILITY_E;

create or replace editioning view EM_LCMLOCK_REG as select lock_num,lock_client,lcm_mode,status,lock_time,lock_release_time from EM_LCMLOCK_REG_E;

create or replace editioning view EM_NZDTLCM_INFO as select lcm_edition_name,created,creation_time,lcm_patch_nums,lcm_op_id,lcm_op_name from EM_NZDTLCM_INFO_E;

create or replace editioning view EM_WORKING_EDITION as select * from EM_WORKING_EDITION_E;

create or replace editioning view EM_NECUTOVER_SYNONYMS as select * from EM_NECUTOVER_SYNONYMS_E;



