BI Publisher (MOSC)

MOSC Banner

XMLP_SCHED_OUTPUT very BIG : how to delete obsoletes reports ?

edited Nov 5, 2013 4:46PM in BI Publisher (MOSC) 4 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center