Dropping ICON

[Dionysis]

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?

[cavagnaro]

Never with ICON but many times with ETL and ODS DB...as long as you create them with same credentials you should not have issues later...it is a "simple" DB task.

[Dionysis]

Yes, a "simple" DB task.

However if it goes wrong and I need to restore 400 Gb of Icon data GIM will not update for a week while I get it going again! 

[cavagnaro]

Ah well, next option is clone the server...one fails, shut it down and power up the old one.