UNSUPPORTED way to delete scheduled workbook in Discoverer

Purely UNSUPPORTED way to delete scheduled workbook in Discoverer

Needs testing from your side and please do it with proper backup.

I have been recently working on a datacenter migration project that involved Discoverer.

After the migration some users who had large number of Discoverer Scheduled workbook had issues when click on Manage Schedule Workbook.

By documentation when a Discoverer Administrator in the admin edition set the scheduled results to be deleted and then the user logs in and logs out the workbook and its associated database objects gets deleted automatically.

Unfortunately this did not work for two of my users because of their mass schedules.

Here is a backend work that I did.

SQL> DELETE FROM EUL5_BATCH_PARAMS WHERE BP_CREATED_BY='TESTUSER';

SQL> DELETE FROM EUL5_BQ_DEPS WHERE BQD_CREATED_BY='TESTUSER';

SQL> DELETE FROM EUL5_BQ_TABLES WHERE BQT_CREATED_BY='TESTUSER';

SQL> DELETE FROM EUL5_BATCH_QUERIES WHERE BQ_CREATED_BY='TESTUSER';

SQL> DELETE FROM EUL5_BATCH_PARAMS WHERE BP_CREATED_BY='TESTUSER';

SQL> DELETE FROM EUL5_BATCH_SHEETS WHERE BS_CREATED_BY='TESTUSER';

SQL> DELETE FROM EUL5_BATCH_QUERIES WHERE BQ_CREATED_BY='TESTUSER';

SQL> DELETE FROM EUL5_BR_RUNS WHERE BRR_CREATED_BY='TESTUSER';

SQL> DELETE FROM EUL5_BATCH_REPORTS WHERE BR_CREATED_BY='TESTUSER';

SQL> COMMIT;

Scripts to delete the objects

SQL> SELECT LOWER('DROP PACKAGE TESTUSER.'||OBJECT_NAME||';')CMD FROM DBA_OBJECTS WHERE OWNER='TESTUSER' AND OBJECT_TYPE='PACKAGE' ;

SQL> SELECT LOWER('DROP TABLE TESTUSER.'||OBJECT_NAME||';')CMD FROM DBA_OBJECTS WHERE OWNER='TESTUSER' AND OBJECT_NAME LIKE 'EUL5_B%' AND OBJECT_TYPE='TABLE' ;

I hope this will be used with proper testing.