Ok, so I’ve got another odd question.
Our main ICON DB is approaching 400 Gb and now the DB is out of storage space. Previously we were using ICON for certain reporting information which we couldn’t get from GIM, but now we don’t need it anymore and I need the space.
Running the Purge jobs on a DB this big isn’t really viable, it takes approximately 2 hours to purge 5 days! Plus it doesn’t actually clear any space as with Oracle DB’s the datafiles don’t shrink when you empty them out, they just sit there waiting to be filled again.
So what I would like to do is this:
drop user icon cascade;
(for the non SQL types: Delete the ICON database)
Scary!
Once dropped I will create a new ICON db with the same name and credentials and start up ICON again. All the while my secondary ICON will be collecting the data missed by the primary one.
So my question is:
Has anyone done this? Can it be done? Am I going to break the world?
