Has anyone ever had to delete large quantities of data from OnDemand? We have about 365 million documents -- that is the number of individual rows in the application group tables. These were loaded in larger batches -- sometimes up to 10,000 documents in one batch. The size of this data in the our cache folders is about 480 GB. These are associated with 7 application groups which will not need to exist after this data is removed.
We are running OnDemand v7.1.2.11 on Solaris. Our data is in cache only.
We've used "arsadmin unload" for deleting several batches at once, but never for this volume of data. Is this the best option?
If we just delete the application groups, I believe that would probably drop the associated database tables, but would that remove the data in cache also?
What about the impact while we're unloading/deleting all of this data?
Thanks!
Paula Guillory
Chevron Information Technology Company