DELETE BB database users and tablespaces after failed installation

1. Query the list of Blackboard users created in the database.

SELECT username, account_status FROM dba_users;

2. Delete the users

DROP USER BBLEARN CASCADE;

DROP USER BBLEARN_ADMIN CASCADE;

DROP USER BBLEARN_CMS_DOC CASCADE;

DROP USER BBLEARN_CMS CASCADE;

(*) just an example depending on the result for item (1).

3. Delete the tablespaces

DROP TABLESPACE BBLEARN_INDX INCLUDING CONTENTS AND DATAFILES;

DROP TABLESPACE BBLEARN_ADMIN_DATA INCLUDING CONTENTS AND DATAFILES;

DROP TABLESPACE BBLEARN_ADMIN_INDX INCLUDING CONTENTS AND DATAFILES;

DROP TABLESPACE BBLEARN_DATA INCLUDING CONTENTS AND DATAFILES;

DROP TABLESPACE BBLEARN_CMS_DOC_INDX INCLUDING CONTENTS AND DATAFILES;

DROP TABLESPACE BBLEARN_CMS_INDX INCLUDING CONTENTS AND DATAFILES;

DROP TABLESPACE BBLEARN_CMS_DATA INCLUDING CONTENTS AND DATAFILES;

DROP TABLESPACE BBLEARN_CMS_DOC_DATA INCLUDING CONTENTS AND DATAFILES;

(*) Depending on the tablespaces created by the installer.

4. Remove /usr/local/blackboard