It sounds like you are using 2 infinite planes for your terrains which is why you either have a desert or an ocean. You need to use a water plane then create a terrain for your sand and follow what has been posted above.