In the wikipedia article on Model Theory in the section on Categoricity it is said that:
As observed in the section on first-order logic, first-order theories cannot be categorical, i.e. they cannot describe a unique model up to isomorphism, unless that model is finite.
And in the linked article on first order logic they refer to the Löwenheim-Skolem-Theorem, which states that every first order sentence that has an infinite model, already has a countable model. But what if the only model is already countable, then Löwenheim-Skolem does not give anything new, so why then could this sentence not be categorical?
The compactness theorem for first-order logic gives us the upwards Löwenheim–Skolem theorem, and that means that if $T$ is a theory that has an infinite model, then it has an infinite model of every cardinality. In particular, assuming $\sf ZFC$, there is a proper class of different cardinalities, so there are at least two. And two models of two different cardinalities cannot be isomorphic.
What is surprising, however, is that for uncountable cardinals, if $T$ is a theory that is $\kappa$-categorical for one uncountable cardinal (namely, all models of size $\kappa$ are isomorphic), then it is $\kappa$-categorical for all uncoutnable cardinals.
What the downwards Löwenheim–Skolem does tell us is that as far using models to determine provability, or consistency, countable models are enough.