Content Store Maintenance

[ghostraider]

Hi All, Could you please provide me any tips about maintaining the Cognos Content Store. We are moving our Content Store from Oracle 9i to 10g and i would like to clear up all the unnecessary stuff before we make the move. Our developers have a lot of unnecessary reports and i think the first step is to have them delete all these reports. Please let me know about any other steps to have better performance from the content store.

Thanks!!

[ducthcogtechie]

Create an empty content store in 10G.
In the current system, select export public folders, and only tick what you need.
import that in the new schema, and you willl probably have lost some weight.