Cleanup of files uploaded to Oracle Portal
Jan 9th 2008vesterliOracle Portal
When you upload content to Oracle Portal, it ends up in the WWDOC_DOCUMENT$ table and the content can be retrieved using WWDOC_ADMIN.GET_DOCUMENT_BLOB_CONTENT.
But what happens if you upload files to a portlet and they are not used as items? Do they just hang around, cluttering WWDOC_DOCUMENT$?
Fortunately not. You might not be aware that Portal installs a session cleanup job (with DBMS_JOB), running every 24 hours. This job cleans up after sessions more than 7 days old, and one of the things cleaned up is records in WWDOC_DOCUMENT$ that have not become items (i.e. the PATHID column value is 0 (zero)).
This of course also means that you should move the content to a table of your own if you intend to keep it…
Refer to the Portal documentation or Metalink note 336203.1 for more information.
No Comments »