[GDAL-DEV] ogr2ogr -f "ESRI Shapefile" - problem

[abhay menon]

hello Frank and list,

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.

that why i have created a batch process hence i faced this problem.

is there a option in ogr2ogr where i can spilt the dataset into small unit
of shapefile in one go.
as process thru batch is slow and units to create is more than 6000*3 files
in shape.

-- 
Best Regrads

Abhay Menon



On 5/26/06, Frank Warmerdam <warmerdam at pobox.com> wrote:
>
> abhay menon wrote:
> > Hello List,
> >
> > recently was trying to extract shapefiles from an oracle database in
> > batch mode
> > it seem that ogr2ogr is not allowing to create shapefile more 168 in
> > numbers.
> >
> > i gave a simple instruction through the command line in same folder but
> > the operation was terminated by saying
> > *"D:\batch1\xyz169.DBF file could not be created"*
> > where as the xyz169.shp and xyz169.shx where created.
> > also did the same by changing the folder name it was successfully
> > created. so changed my logic in the batch mode operation creating
> > temporary place and  moving it to the actual folder.
> >
> > I am puzzled by the fact that why ogr2ogr failed in creating the
> > shapefiles more than 168 in the same folder. Is it a limitation of the
> > shapefile or is it set nature of the DBF file that not more than 168
> > number file could be created at one folder in one go??
>
> Abhay,
>
> 3 * 168 is 504.  I suspect you have a limit of 512 open files at a time on
> your system and that this has been hit with the 168's shapefile set and
> a few other files (ie. oracle connections).  I imagine you could invoke
> ogr2ogr on one layer at a time and things would be ok.
>
> Some operating systems also provide mechanisms to increase the maximum
> number of open file descriptors.  I have no clue if or how this is
> possible
> on windows.
>
> Best regards,
> --
>
> ---------------------------------------+--------------------------------------
> I set the clouds in motion - turn up   | Frank Warmerdam,
> warmerdam at pobox.com
> light and sound - activate the windows | http://pobox.com/~warmerdam
> and watch the world go round - Rush    | President OSGF, http://osgeo.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20060526/a09207bc/attachment.html