How do I completely uninstall CABI from UIM 20.x? How to remove CABI from UIM?
This KB provides steps to completely remove/uninstall CABI from UIM.
You may need to uninstall and reinstall CA Business Intelligence (CABI) Bundled for one or more of the following reasons:
Here is an additional drop table script for Oracle:
ALTER SESSION SET NLS_SORT = BINARY_AI NLS_COMP = LINGUISTIC;
BEGIN
FOR c IN ( SELECT table_name FROM user_tables WHERE table_name LIKE 'QUARTZ%' OR table_name LIKE 'JI%'
OR table_name LIKE 'ProfilingRecord'
OR table_name LIKE 'qrtz_job_details'
OR table_name LIKE 'qrtz_simple_triggers'
OR table_name LIKE 'qrtz_cron_triggers'
OR table_name LIKE 'qrtz_simprop_triggers'
OR table_name LIKE 'qrtz_blob_triggers'
OR table_name LIKE 'qrtz_calendars'
OR table_name LIKE 'qrtz_paused_trigger_grps'
OR table_name LIKE 'qrtz_scheduler_state'
OR table_name LIKE 'qrtz_fired_triggers'
OR table_name LIKE 'qrtz_locks'
OR table_name LIKE 'qrtz_triggers')
LOOP
EXECUTE IMMEDIATE 'DROP TABLE ' || c.table_name || ' CASCADE CONSTRAINTS';
END LOOP;
END;