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 1 down vote favorite

I have 35million records (tomtom multinet) of file gdb file in my desktop machine. I need to upload this file into Oracle spatial as SDO_geometry file.

I already tested the connection with small size file gdb file and it is success.

Is there any best practice here to upload this huge file (from a desktop machine -windows 7 to oracle ?

my env: arcgis desktop 9.3.1 (sp2) and arcsde (arccatalog and arsde are in same machine), oracle 10g (db is in different location).

Or, whether i have to upload it as splittted files (5m rows each) into oracle spatial, then doing append in a file through arccatalog. I have default dbtune.sde file, commit interval 1000.

Pls. share your experience in this.

share|improve this question
Hi, I have made the commit interval as 10000. The 48mn rows (9gb) got loaded in 20hrs. Also, before loading the fGDB, i have removed the spatial index created by the arccatalog. – vadivelan Apr 30 '12 at 18:05

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.