Documents are not cleaned from the wwdoc_document$ table after removing File Items from the Portal UI (Doc ID 336203.1)

Last updated on SEPTEMBER 11, 2015

Applies to:

Portal - Version 9.0.4.2 to 10.1.4.2 [Release 10g to 10gR2]
Information in this document applies to any platform.
Checked for relevance on 11-Sep-2015

Symptoms

The document table is eating the disk space.
After removing an item from the Portal UI the space in the document table doesn't decreases.
So it seems the document is not removed from the document table.

Running this query before and after removing the file items shows the same number of rows:

select count(*) from wwdoc_document$;

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms