Compressor oil is not expensive. I replaced mine and I think I paid $8 for a pint.
Auto/motorcycle oil would not be right as it has detergents to pick up junk and suspend it so the oil filter can take it out. You would want non-detergent oil so the dirt and shavings settle to the bottom.