Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 5 down vote favorite

The title says it all really – I have a single file named 'a0000000.gdbtable’ in my default file geodatabase that is 60 GB in size. I have a number of other files with .gdbtable extension that aren't nearly as big. Just wondering what it is and whether I can delete it or make it smaller? It's taking up too much space!

share|improve this question

2 Answers

up vote 7 down vote accepted

Have you tried running the Compact tool on your file geodatabase? Compacting could get your geodatabase size down. I would not recommend deleting any of the files in the file geodatabase structure, as you are likely to kill it doing that. You say the "default" file geodatabase...personally I try to not keep anything in there that is of any importance and every once in a while delete the whole geodatabase and recreate a new one just to keep it trim and snappy. If you have edited the geodatabase a lot, then Compacting might indeed help.

share|improve this answer
2  
Compacting is a good way of keeping the indexes down so +1 from me. However, if you are accessing the data through python, the compacting of it can create access issues. If you don't need the data in it i.e. you are creating new tables in it all the time, another option is to write a scrip that deletes it and recreates it on the fly and just run that script as a precursor to doing any work on it. Works a treat for me. – Hairy Jan 30 '12 at 15:08
1  
Wow, that worked really well - went from 60GB down to 3! Exactly what I was after, thanks! Jay – jay Feb 2 '12 at 4:09
up vote 0 down vote

You can move the data that you don't want to edit to a separate file database and compress that database.

share|improve this answer
ok thanks for the suggestion - compacting worked a charm but will keep moving and compressing in mind.cheers – jay Feb 2 '12 at 4:10

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.