2

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.

PolyGeo ♦
65.5k29 gold badges115 silver badges350 bronze badges
asked Mar 29, 2012 at 1:32
2
  • 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. Commented Apr 30, 2012 at 18:05
  • It looks like you resolved this unaided. I think it would be useful for you to copy your solution from the current Comment to an Answer that you can then self-Accept. Commented Oct 10, 2013 at 3:51

1 Answer 1

0

I have made the commit interval as 10,000 in the sde config. Around 48 millions rows (9gb - road network) got loaded in ~20hrs. Also, before loading the fGDB, i have removed the spatial indexes created bfore using Arc Catalog

answered Oct 28, 2013 at 18:30

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.