Is there anyway to achieve or purge data in DMS solution? I am looking for a solution for that because db is getting bigger, need to purge data in CLOB.
Thanks for advice
Documents that are not referenced by any PPM entity (Request, Project, etc.) will be automatically deleted from the DB by the Document Cleanup Service (if they are older than 1 day).
So if you want to delete documents from DB, you should delete whatever entity holds them.
Now, if the space in your LOB tablespace is not freed up after deleting documents BLOB contents, you might want to review your tablespace creation options (See http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7246820117571 for example).