We have project in which we are required to delete some Siebel file attachments from the Siebel CRM system but the associated row in the S_XXX_ATT table should not be deleted.
I am aware we can archive and delete file attachments associated to a database table and we have this established for our Siebel system currently. But now, the requirement is to only delete the attachment after archival and the row of the table should remain in the db.
Is there a way Optim can handle this?
We are using Optim 7.3.1. and Oracle 10g , Siebel 8.1
Any quick response would be appreciated since we have to get back to our business soon.