The Great Wall was not very effective. China has been successfully invaded many times, including (but not limited to) the Jurchen, Mongols, Manchus and many many others.

And the Great Wall is an exception. Most walls were around cities, not countries.