I don't think they have to be in opposition, though oppositional people on both sides like to think they must :) Both are ways of structuring human experience, but they're at their best when they don't try to tackle each other's territories; scientists arguing theology are often just as laughable as theologians arguing science... Different disciplines, different tools, different foci of interest: different, not opposed.