Remove Template, Data Definition, Bursting File

Many times we will be getting requirement to remove bursting file from data definition. Unfortunately Oracle does not provide front end option to remove the bursting control file.

We can use an alternative solution to remove bursting control file from data definition. Use below piece of code to remove control file

DELETE

FROM XDO_LOBS

WHERE LOB_CODE='XXEMP_INFORMATIONS'

AND LOB_TYPE='BURSTING_FILE';