13 Data Management Assembly for Oracle Data Integrator Uninstall

Note:

This section is applicable only to uninstall Data Management Assembly only from the development environment.

Execute the following commands to drop user schemas by connecting to the system user. If you have installed Data Model Assembly, replace the user schema name and tablespace names with the values provided during the installation.

drop user <HCD_WORK_REP_72> cascade;
drop user <HCD_MASTER_REP_72> cascade;
drop user <WIL_WORK_REP_72> cascade;
drop user <TL_MASTER_REP_72> cascade;
drop user <CDM_WORK_REP_72> cascade;
drop user <TL_WORK_REP_72> cascade;
drop user <WIL_MASTER_REP_72> cascade;
drop user <CDM_MASTER_REP_72> cascade;
drop user <WIL_HMC72> cascade;
drop user <HCD_HMC72> cascade;
drop tablespace <hmc_temp72> INCLUDING CONTENTS and datafiles;
drop tablespace <odirep_temp72> INCLUDING CONTENTS and datafiles;
drop tablespace <odirep_ts72> INCLUDING CONTENTS and datafiles;
drop tablespace <hmc_ts72> INCLUDING CONTENTS and datafiles;
drop tablespace <wil_odi_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <hcd_odi_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <cdm_odi_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <tl_odi_ts> INCLUDING CONTENTS and datafiles;
commit;

Invoke the rcu script available in the $ODI_HOME/oracle_common/bin/ folder. For example:

cd $ODI_HOME/oracle_common/bin/ ./rcu

Navigate to the ODI domains directory and drop all the OHF domain folders created during the OHF installation. For example:

cd $ODI_HOME/user_projects/domains rm -rf ${RCU_PREFIX}_WIL_domain_01 rm -rf ${RCU_PREFIX}_AT_domain_01 rm -rf ${RCU_PREFIX}_CDM_domain_01 rm -rf ${RCU_PREFIX}_TL_domain_01