XMLP_SCHED_OUTPUT very BIG : how to delete obsoletes reports ?
Hello,
On our database BI Publisher 10 G, we have a table XMLP_SCHED_OUTPUT very BIG, it is store a DOCUMENT_data and XML_DATA for reports.
I have some reports not used by application, can I delete a output ( XMLP_SCHED_OUTPUT row) for this report?
can i use the queries below to delete the obsolete report ?
-- for example (report with job_id=3) :
delete from XMLP_SCHED_OUTPUT where JOB_ID=3;
delete from XMLP_SCHED_JOB where JOB_ID=3
commit;
Exist other linked rows in the tables to delete?
Regards,
PS- I Back up the database first to avoid any errors