Am new to spatial data of oracle... the oracle manual mentions the following steps in order :
1)Creates a table to hold the spatial data.
2) Inserts rows for areas of interest.
3) Updates the USER_SDO_GEOM_METADATA view to reflect the dimensional information for the areas.
4) Creates a spatial index.
5) Performs some spatial queries.
My question is : is it necessary to follow this order ? can i do order 1),3),4) and then 2) and 5) ??
Why what difference does it make if I update user metadata and spatial index before doing DMLs ?? Also if it does make a difference do I need to update both of them after each DML transaction ??
Edited by: 919436 on Oct 27, 2012 5:35 PM