I want to convert a spatial table into a non-spatial table using SQL Developer, what would it be the most efficient/elegant way of doing it?
Obviously, first I would make a copy of it before changing anything.
- DELETE the 'SHAPE' and the 'SE_ANNO_CAD_DATA' columns.
- DROP the Spatial Metadata/Spatial indexes.
- Export the table into a text/csv/excel/etc file and upload it as a new table without spatial attributes.
Aucun commentaire:
Enregistrer un commentaire