Does the length of copper wire affects its resistivity?

No. Resistivity is a physical constant, and is unaffected by the dimensions of the wire.