How do I alter a table in TOAD to create a SDO_GEOMETRY data type?
In the Alter Table dialog, click the dropdown arrow in the ‘datatype’ column. Scroll all the way down and choose “User defined (another schema)”. A dialog will appear and you can choose a sdo_geometry object from this list.
