I want to convert a spatial table, registered with Geodatabase (SDE), 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.
Having said that, I would also like to maintain the foreign keys, indexes and constraints of the non-spatial columns.
which would it be the best option from below?
- 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 and then, re-create the foreign keys, etc.