Why was I having a bad dream and sweating excessively and felt cold at the same time?

This symptom is caused from a fear factor. You sweat because you were scared(or fear) and because sweat takes away body temperature, you feel cold( because your body sweat out of fear in normal temperature).