DMS Purge Issue (145 Views)
Reply
Trusted Contributor
Kerim KILIC
Posts: 162
Registered: ‎04-01-2011
Message 1 of 2 (145 Views)

DMS Purge Issue

Hello,

 

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

 

Kerim

HP Expert
Etienne_Canaud
Posts: 183
Registered: ‎10-15-2010
Message 2 of 2 (128 Views)

Re: DMS Purge Issue

Hi Kerim,

 

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).

 

Thanks,

Etienne.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.