jeudi 26 février 2015

Convert spatial table into non-spatial table in Oracle


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.



  1. DELETE the 'SHAPE' and the 'SE_ANNO_CAD_DATA' columns.

  2. DROP the Spatial Metadata/Spatial indexes.

  3. 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