Digital beach
My little place on the web
Digital beach Blog / Articles Categories XML Publisher Removing Bursting control files
Removing Bursting control files
Written by Patrick van Zweden   

When you look closely at the page where you can upload you're data templates and bursting control files you'll notice an odd thing...... There's no delete button.

Take a look at the screenshot below for example:

xml publisher data definition screenshot

The schema, data template, preview data and bursting control file all have no way to be deleted. Sometimes you attach for example a bursting file by mistake or want to remove the preview data. So how is this done?

Unfortunately, the only way is to delete the data from the tables itself.

The files are all stored in the xdo_lobs table. All using a specific lob_type. The bursting control file for example has the lob_type  'BURSTING_FILE'.

So deleting a control file will be done using the following SQL:

  1. DELETE
  2. FROM XDO_LOBS
  3. WHERE LOB_CODE=<DATA_DEFINITION_CODE>
  4. AND LOB_TYPE='BURSTING_FILE'
  5.  

Hopefully Oracle will create a nicer solution in the future.