You need a pretty big pump (I tried a small one on my honda) for it to work, but when you get a big (and efficient!) enough pump it will work very well (just look at any professional roadrace engine, they all use a dry sump system).
I was thinking of an old roots supercharger for this purpose.