The zone, which was based around the city's harbour, saw police turn a blind eye to prostitutes and their clients.
However, Grampian Police said that from Monday anyone soliciting prostitutes in the area would face arrest.
Supporters of the Street Prostitute Management Zone have called for an alternative scheme to be put in place.
About 130 prostitutes had been using the zone since it was introduced in July 2001.
Although police carried out regular patrols in the area, they were focused on protecting prostitutes from violence.