Engineering-Tech Wiki

User Tools

Site Tools

You are here: start » contrib » shp2ndm
Trace:
contrib:shp2ndm

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
contrib:shp2ndm [2007/07/20 17:25] – sleleivacontrib:shp2ndm [2007/07/23 20:25] – fixed COMMIT; line between BEGIN END; sleleiva
Line 1: Line 1:
-  * Import a Shapefile into Oracle Spatial as a normal vector map;+  * [[contrib:shp2oracle_spatial|Import a Shapefile into Oracle Spatial]] as a normal vector map;
   * Replace all occurrences of SHP_TABLE (case sensitive, can be part of a word) in the script below with the table name of the imported map from Shapefile (copy all script from below to a text editor and perform that replace);   * Replace all occurrences of SHP_TABLE (case sensitive, can be part of a word) in the script below with the table name of the imported map from Shapefile (copy all script from below to a text editor and perform that replace);
   * Copy/Paste (in Linux: select text and then use middle mouse button or Shift+Insert to paste it in a console) the script line-by-line, follow any severe errors (ignore ones, when it writes that table cannot be dropped when it does not actually exist :) and the like).   * Copy/Paste (in Linux: select text and then use middle mouse button or Shift+Insert to paste it in a console) the script line-by-line, follow any severe errors (ignore ones, when it writes that table cannot be dropped when it does not actually exist :) and the like).
Line 37: Line 37:
 EXECUTE SDO_TOPO_MAP.LOAD_TOPO_MAP('SHP_TABLE_MAP_CACHE', 'true'); EXECUTE SDO_TOPO_MAP.LOAD_TOPO_MAP('SHP_TABLE_MAP_CACHE', 'true');
  
--- copy/paste everything in one go between BEGIN and COMMIT; (including):+-- copy/paste everything in one go between BEGIN and termination line with symbol “/” (including):
 -- this one will demand a considerable amount of time -- this one will demand a considerable amount of time
 BEGIN BEGIN
Line 51: Line 51:
 END LOOP; END LOOP;
 END; END;
-COMMIT;+/
  
 -- commit topology changes -- commit topology changes