13 Data Model Uninstall

This chapter describes how to uninstall the Oracle Healthcare Foundation Data Model.

Note:

Oracle recommends that you uninstall the Data Model only from the development environment. Also, make sure you have backups of the user schemas before dropping them.

Execute the following commands to drop user schemas by connecting to the system user. Replace the user schema names and tablespace names with the values provided during the installation.

drop user <hdi> cascade;
drop user <hdm> cascade;
drop user <hcd> cascade;
drop user <odb> cascade;
drop user <cdm> cascade;
drop user <ent> cascade;
drop user <job> cascade;
drop user <svc> cascade;
drop tablespace <hdi_temp> INCLUDING CONTENTS and datafiles;
drop tablespace <hdm_temp> INCLUDING CONTENTS and datafiles;
drop tablespace <hcd_temp> INCLUDING CONTENTS and datafiles;
drop tablespace <odb_temp> INCLUDING CONTENTS and datafiles;
drop tablespace <cdm_temp> INCLUDING CONTENTS and datafiles;
drop tablespace <ent_temp> INCLUDING CONTENTS and datafiles;
drop tablespace <job_temp> INCLUDING CONTENTS and datafiles;
drop tablespace <svc_temp> INCLUDING CONTENTS and datafiles;
drop tablespace <hdi_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <hdm_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <hcd_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <odb_data_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <odb_index_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <odb_lob_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <cdm_data_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <cdm_index_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <ent_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <job_data_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <job_index_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <job_store_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <job_lob_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <job_tbs_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <svc_ts> INCLUDING CONTENTS and datafiles;