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:
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:
DELETE FROM XDO_LOBS
WHERE LOB_CODE=<DATA_DEFINITION_CODE>
AND LOB_TYPE='BURSTING_FILE'
;Hopefully Oracle will create a nicer solution in the future.