We are using Vignette IDM 19.2 on top of Oracle 9.2 i. Vignette (ex Tower) creates a table to store references of documents. In our case we end up with a table containing several bilion rows, thus adding new documents to the IDM storage becomes slower and slower. We have tried to create an IDM application in a standard way, drop the table and re-create it as a partitioned table. Unfortunately, for reasons which even Vignette is not (yet?) able to explain, the table is not recognized by the IDM application.
We are thus looking for other ways of dealing with such a large table (still growing). Would you have any advice on that subject? Any guidance would be very much appreciated!
This was first published in December 2005