Controversial plans to house hundreds of asylum seekers at a military base have been scrapped with opponents hailing the decision a 'victory for common sense'.