Bad enough that the oil pan will have to be removed and the rod bearing replaced if that is all the damage that has been done. You will also need to find out why this happened.
Rod bearing (short for connecting rod bearing) Is the bearing where the connecting rod is attached to the rotating crankshaft.
A spun--Bad rod bearing. NO OIL PRESSURE.
If the bearing has not spun or seized, you drop the oil pan, take the rod cap off of the rod and put the new bearing in. The bearing is in two pieces, half in the rod and half in the rod cap. If the bearing has spun, you should remove the crankshaft and either have the rod journal polished or machined for a thicker bearing.
bad oil pump or a spun rod\main bearing
Bad bearing? Bad connecting rod?
A bad connecting rod bearing can do this
The easiest repair is to replace the engine. Otherwise the crank shaft will need replaced/remachined and the connecting rod will need replaced. Basically a complete overhaul.
When rod bearing clearance is too tight the end result is what is called a spun bearing -- definitely a bad thing. Bearing clearance is the difference between the inside diameter of the bearing and the outside diameter of the crankshaft journal to which it is clamped. The bearing is supplied pressurized oil fed by the oil pump, it should never touch the crankshaft journal but should always float on a wedge of oil. If the clearance is too tight the bearing touches or drags on the crankshaft journal and the journal grabs the bearing and spins it inside the housing into which it is clamped -- which in the case of a rod bearing is the big end of the connecting rod. Once this happens it all pretty much self destructs as it chews up the big end of the connecting rod and the crankshaft journal as well.
A main bearing gives the crankshaft a smooth surface to spin on, and a rod bearing, provides a surface for the connecting rod to rotate on.
For testing purposes only you can disconnect and reconnect one spark plug at a time. When you get to the cylinder with the bad rod bearing the noise will stop.
There isnt any
Only if it all leaks out.