Bursting control file

[Laurel]

Hi Dear Erman! :)
How are you ? I hope all is fine  :)

We are going to change email server address and i know that its used in alot of bursting control files..
Do you know how to query those from database ?
Cannot find away.. Now its especially difficult as oracle has changed the support pages.. arghhh

The only thing  what i see is that i need to download each one from xml publisher admin... and its takes alot of time..

Any hints ?
Thx alot!
Best wishes
Laurel

[ErmanArslansOracleBlog]

Hi Laurel,

thank you. I hope you are good as well :)

You can get that data using a query on tables like XDO_LOBS,  XDO.XDO_TEMPLATES_B, XDO.XDO_DS_DEFINITIONS_B

https://etrm.live/ .. ETRM is your friend in finding the relevant tables and their definitions

you should use the capabilities of dbms_lob package (dbms_lob.substr,  dbms_lob.instr and stuff like that) to get the data in the format that you need.. So, I think you can get it by writing a SQL for querying XDO_LOBS..

The following blog post shows some queries in this context.. https://appselangovan.blogspot.com/2014/04/query-for-data-definition-and-template.html

Gemini or Chatgpt can also help you for building your query. :)