5 DeInstallation

This chapter explains how to deinstall Oracle Retail Data Model.

Follow these steps to deinstall Oracle Retail Data Model:

Note:

Steps 6, 7, and 8 are required only if you installed the sample reports.

Drop Oracle Retail Data Model users and related database objects. To drop ORDM users and related database objects, log in as a DBA and execute the following commands:
```
SQL>drop user bia_rtl cascade;
SQL>drop user bia_rtl_mining cascade;
SQL>drop user bia_rtl_olap cascade;
```

Drop Oracle Retail Data Model tablespaces, as follows:

SQL>drop tablespace dw_aggregate_idx including contents and datafiles;
SQL>drop tablespace dw_derived_idx including contents and datafiles;
SQL>drop tablespace dw_mvlog_tbs including contents and datafiles;
SQL>drop tablespace dw_aggregate_tbs including contents and datafiles;
SQL>drop tablespace dw_derived_tbs including contents and datafiles;
SQL>drop tablespace dw_reference_idx including contents and datafiles;
SQL>drop tablespace dw_base_idx including contents and datafiles;
SQL>drop tablespace dw_dm_tbs including contents and datafiles;
SQL>drop tablespace dw_reference_tbs including contents and datafiles;
SQL>drop tablespace dw_base_tbs including contents and datafiles;
SQL>drop tablespace dw_lookup_tbs including contents and datafiles;
SQL>drop tablespace BIA_RTL_OLAP including contents and datafiles;
SQL>drop tablespace BIA_RTL_OLAP_TEMP including contents and datafiles;

If you selected partitioning when you installed Oracle Retail Data Model, drop the partition tablespaces. The names of the partition tablespaces have the following forms:
```
DWA_TBS_yyyymm
DWB_TBS_yyyymm
DWD_TBS_yyyymm
```
yyyymm are the 4-digit year and 2-digit month numbers that indicated partition start and end.

Drop the partition tablespaces using commands like the following for all values of yyyymm:
```
drop tablespace DWA_TBS_yyyymm including contents and datafiles;
drop tablespace DWB_TBS_yyyymm including contents and datafiles;
drop tablespace DWD_TBS_yyyymm including contents and datafiles;
```
Remove ORDM from the inventory:
```
cd ORACLE_HOME/oui/bin
./runInstaller  
```
Click Deinstall Products, select Oracle Retail Data Model 10.2.2.0.0 and click Remove, and then click Yes.
After the deinstall finishes, click Exit to end the installer.
Delete RBIAII.rpd in the directory BIHome/Server/Repository.
Delete the folder rbiaii in BIDataHome/web/catalog.
Delete the following line from BIHome/Server/Config/NQSConfig.INI:
```
Star    =    RBIAII.rpd, DEFAULT
```