{"id":1295,"date":"2013-02-15T23:46:52","date_gmt":"2013-02-15T22:46:52","guid":{"rendered":"http:\/\/www.switchbl8.nl\/blog\/?p=1295"},"modified":"2013-02-15T23:49:14","modified_gmt":"2013-02-15T22:49:14","slug":"loading-3d-points-into-oracle-with-sql-loader","status":"publish","type":"post","link":"https:\/\/www.switchbl8.nl\/blog\/2013\/02\/loading-3d-points-into-oracle-with-sql-loader\/","title":{"rendered":"Loading 3D points into Oracle with SQL Loader"},"content":{"rendered":"<p>I received some files with only coordinates, which had to be loaded into Oracle. It&#8217;s not super difficult, but I thought I&#8217;d share it anyway. The files contain some comment lines first, easily recognized the the hash (#) as the first character. The rest of the lines are x, y and z separated by spaces, like this:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n#&#x5B;MetadataBegin]\r\n#&#x5B;OrderNumber]2013001\r\n#&#x5B;Measured by]Piet\r\n#&#x5B;MeasureDate]30-1-2013\r\n#&#x5B;MetadataEnd]\r\n 58392.50 439762.50 -0.01\r\n 58397.50 439762.50 -0.03\r\n 58402.50 439762.50 -0.03\r\n 58407.50 439762.50 -0.03\r\n<\/pre>\n<p>The control file should be like this (change the filename etc):<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nOPTIONS (DIRECT=TRUE,MULTITHREADING=TRUE)\r\nLOAD DATA\r\nINTO TABLE DEPTHDATA\r\nWHEN 1-1&lt;&gt;'#'\r\nFIELDS TERMINATED BY ' '\r\n(ID SEQUENCE(1,1),\r\n GEOMETRY COLUMN OBJECT\r\n (\r\n  SDO_GTYPE CONSTANT &quot;3001&quot;,\r\n  SDO_POINT COLUMN OBJECT\r\n   (X FLOAT EXTERNAL TERMINATED BY ' ' ,\r\n    Y FLOAT EXTERNAL TERMINATED BY ' ' ,\r\n    Z FLOAT EXTERNAL TERMINATED BY ' ' )\r\n   )\r\n)\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>I received some files with only coordinates, which had to be loaded into Oracle. It&#8217;s not super difficult, but I thought I&#8217;d share it anyway. The files contain some comment lines first, easily recognized the the hash (#) as the first character. The rest of the lines are x, y and z separated by spaces, <a href='https:\/\/www.switchbl8.nl\/blog\/2013\/02\/loading-3d-points-into-oracle-with-sql-loader\/' class='excerpt-more'>[&#8230;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[132,79],"class_list":["post-1295","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-oracle","tag-spatial","category-1-id","post-seq-1","post-parity-odd","meta-position-corners","fix"],"_links":{"self":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/1295","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/comments?post=1295"}],"version-history":[{"count":4,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/1295\/revisions"}],"predecessor-version":[{"id":1298,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/1295\/revisions\/1298"}],"wp:attachment":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/media?parent=1295"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/categories?post=1295"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/tags?post=1295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}