topic Re: Memory limits of file geodatabase? in Data Management Questions

Memory limits of file geodatabase?

MattRosales — Tue, 23 Nov 2010 18:59:01 GMT

Hi All,

I've been importing shapefiles into one geodatabase by way of a python script. The database is now 13gb, and even after compacting it, I cannot view or in any way work with the geodatabase, as I get "out of memory" errors. My computer has 8gb of RAM - are geodatabase sizes limited to the amount of installed memory? I am surprised that they do not operate using virtual memory (swap).

Examples of some of the error messages:

Not enough storage is available to complete this operation.; (code 8007000E)
Out of memory
Failed to execute CompressFileGeodatabaseData

Thanks for the insights,

Re: Memory limits of file geodatabase?

HelenYang — Wed, 24 Nov 2010 00:05:09 GMT

Instead of trying to compress the whole gdb, you may try to compress individual feature dataset or feature class.

Re: Memory limits of file geodatabase?

MattRosales — Wed, 24 Nov 2010 19:20:25 GMT

Thanks for the input - unfortunately I can't list the contents of the geodatabase without incurring an out of memory error. The strangest facet of this is arcpy.ListFeatureClasses() returns null, but if I already know the name of a feature class, it can be manipulated, but without being able to list them, I don't know the individual names of the feature classes to compress... arcpy.ListFiles() crashed the last two times I attempted it also. Ugh!

Re: Memory limits of file geodatabase?

VinceAngelo — Wed, 24 Nov 2010 19:57:46 GMT

It sounds like your FGDB was corrupted, and the compress made things worse.

- V

Re: Memory limits of file geodatabase?

MattRosales — Wed, 24 Nov 2010 19:59:39 GMT

Is there any way to repair a FGDB? Or in any case get some sort of diagnostics out of it to know for sure?
Thanks,

Re: Memory limits of file geodatabase?

VinceAngelo — Wed, 24 Nov 2010 20:41:24 GMT

Contact Tech Support; they're the only folks who might have tools like that.

- V