Do you have a standard or fire code you have to follow or want the reference out of??
Yes I have seem flammable storage warehouses protected by water systems only.
Water will control or extinguish the fire.
When you say lubricating oil, would that be free flowing or the thick stuff.
Your question has quite a few variables to give a good answer.
I take it this not in the USA???