Restart RCU installation after failure

Sometimes, RCU installation might fail due to whatever reasons, in that case if you are planning to re-install RCU schema, it complains that "

The specified prefix already exists".

Resolution:

This can be resolved by following below steps.

1. Login to SQLPLUS* using SYS user.

2. Check if there are any entries in the below table.

Select * from System.SCHEMA_VERSION_REGISTRY$; 

3. You might see two entries one for DEV_BIPLATFORM and DEV_MDS.

4. Delete these entries with below SQL.

     Delete from System.SCHEMA_VERSION_REGISTRY$;

5. Then drop the users, DEV_BIPLATFORM and DEV_MDS using the below SQL.

     drop user DEV_BIPLATFORM cascade;

  drop user DEV_MDS cascade;