What happens if I deactivate RSO after the map is generated

My old answer still holds true for 0.14 Factorio and earlier, but the new steam mechanics introduced in 0.15 and up change the rules drastically.

There is, however, still a use case for storing water in tanks, and that's for buffer purposes.

Especially later on you may wind up migrating to a hybrid solar and steam setup for your power usage; in those cases, the draw on your steam engines and/or turbines will be significantly higher at night time. By using tanks to store water and/or heated steam during the daytime you can guarantee a steady supply at night when the draw might otherwise exceed the capacity of your pipe network.

The principle is always the same: Have several assemblers (I call them 'fabbers' due to having read too much Schlock Mercenary) set to "Science pack" standing along a conveyor belt that carries the exact components required, with inserters to keep them filled, and a second belt that carries off the product.

• Red science packs are made by combining a copper plate and an iron gear. The latter is made from iron plates at a rate of 2 plates : 1 gear.
• Green science packs are made from a yellow inserter and a basic conveyor belt -- both of which are constructed from iron plates and iron gears, with basic circuitry tossed in for the former.

This image (taken from this page of the wiki) demonstrates a working setup:

In case it's a little hard to see (the resolution could be better, I admit) here's what's going on:

1. The conveyor belt across the top carries iron plates.
2. The vertical conveyor belt at the right side of the screen carries copper plates.
3. The fabber at the top right takes iron plates and produces gears, which the long inserter drops onto the belt next to the copper plates. This belt then continues horizontally across the screen and carries everything the red pack fabbers on the left need.
4. On the left side just above the belt is a fabber that takes copper plates from the belt and turns them into copper wire, which immediately gets inserted into the circuitry fabber directly above it.
5. The circuitry fabber additionally picks up iron plates from the split belt between the upper two fabbers and creates basic circuitry, which is put into the basic inserter fabber across from it by another long inserter.
6. The fabber to the right of the copper wire fabber builds conveyor belts out of gears picked up from the belt below it and metal plates from the split belt above it, then deposits them on the other side.
7. The inserters and conveyor belts end up moved onto the same belt from opposite sides, which then moves along the right side of the screen and feeds the green science pack fabbers.
8. The red and green pack fabbers deposit their products onto the same belt from different sides, resulting in a single belt carrying green packs on one side and red packs on the other. This belt can then be guided to wherever you've placed your science labs where inserters can use them to fill the labs at need.

As long as the copper and iron plates keep coming, this setup will keep churning out red and green packs without pause.

Setting up an assembly network for blue packs is left as an exercise for the dedicated builder. Happy constructing!