Differences

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

--- contrib:shp2ndm [2007/07/20 17:24] – created sleleiva
+++ contrib: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).
 <code oracle8>
@@ Line 37: / Line 37: @@
 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
 BEGIN
@@ Line 51: / Line 51: @@
 END LOOP;
 END;
-COMMIT;
+/
 -- commit topology changes