>How to change datatypes of een existing fields
You can use Visual Interdev for that. For creating a table, I usually use a script or the Enterprise Manager interface. But, for the updates, as it's not possible with the Enterprise Manager, I use either a script of the Visual Interdev interface.