<div>hello Frank and list,</div>
<div> </div>
<div>what i am trying is to split a dataset from oracle in to small unit of data as shapefile. for which i am firing a queries in -sql statement passing by a unique value base on which the data is to be extract small unit from one single layer in oracle.
</div>
<div> </div>
<div>that why i have created a batch process hence i faced this problem.</div>
<div> </div>
<div>is there a option in ogr2ogr where i can spilt the dataset into small unit of shapefile in one go.</div>
<div>as process thru batch is slow and units to create is more than 6000*3 files in shape.<br> </div>
<div>-- <br>Best Regrads<br><br>Abhay Menon<br> </div>
<div><br> </div>
<div><span class="gmail_quote">On 5/26/06, <b class="gmail_sendername">Frank Warmerdam</b> <<a href="mailto:warmerdam@pobox.com">warmerdam@pobox.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">abhay menon wrote:<br>> Hello List,<br>><br>> recently was trying to extract shapefiles from an oracle database in
<br>> batch mode<br>> it seem that ogr2ogr is not allowing to create shapefile more 168 in<br>> numbers.<br>><br>> i gave a simple instruction through the command line in same folder but<br>> the operation was terminated by saying
<br>> *"D:\batch1\xyz169.DBF file could not be created"*<br>> where as the xyz169.shp and xyz169.shx where created.<br>> also did the same by changing the folder name it was successfully<br>> created. so changed my logic in the batch mode operation creating
<br>> temporary place and moving it to the actual folder.<br>><br>> I am puzzled by the fact that why ogr2ogr failed in creating the<br>> shapefiles more than 168 in the same folder. Is it a limitation of the
<br>> shapefile or is it set nature of the DBF file that not more than 168<br>> number file could be created at one folder in one go??<br><br>Abhay,<br><br>3 * 168 is 504. I suspect you have a limit of 512 open files at a time on
<br>your system and that this has been hit with the 168's shapefile set and<br>a few other files (ie. oracle connections). I imagine you could invoke<br>ogr2ogr on one layer at a time and things would be ok.<br><br>Some operating systems also provide mechanisms to increase the maximum
<br>number of open file descriptors. I have no clue if or how this is possible<br>on windows.<br><br>Best regards,<br>--<br>---------------------------------------+--------------------------------------<br>I set the clouds in motion - turn up | Frank Warmerdam,
<a href="mailto:warmerdam@pobox.com">warmerdam@pobox.com</a><br>light and sound - activate the windows | <a href="http://pobox.com/~warmerdam">http://pobox.com/~warmerdam</a><br>and watch the world go round - Rush | President OSGF,
<a href="http://osgeo.org">http://osgeo.org</a><br><br></blockquote></div>