Project and Portfolio Management Practitioners Forum
cancel

DMS Purge Issue

Highlighted
Kerim KILIC
Honored Contributor.

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

1 REPLY
Etienne_Canaud
Outstanding Contributor.

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.