How to do a bulk load of a database when application are relying on it? In a daily routine, I need to drop and do a bulk load of a database.

The problem is that I have a WebApp relying on that database. So I can't drop the database just like this.

What would be a good way to tackle this problem ?
Do you need to drop and reload the database?  In a case like yours, I would look at a way to synchronize the database with the reference set (the data you are loading).

An alternative approach would be to have two databases.  Load a different one each day.  Configure the webapp so that you can swap databases on the fly.