This discussion is archived
6 Replies Latest reply: May 31, 2013 2:45 AM by Stefan Jager RSS


don123 Newbie
Currently Being Moderated

I am using shp2sdo to load shape files in 11g.
shp2sdo utility creates control file in which it add a key word TRUNCATE.
Is there any parameter in shp2sdo utility to make this as APPEND.
I need to edit control file for every load.

  • 1. Re: shp2sdo
    kc-runner Newbie
    Currently Being Moderated
    I did some searching for shp2sdo and only found shp2sdo.exe. Does anybody know if there is a script for Linux?
  • 2. Re: shp2sdo
    John O'Toole Journeyer
    Currently Being Moderated
    Shp2sdo is old hat and I haven't used it in years. When I want to load occasional Shape files to Oracle I use GeoRaptor ( - when I want to script a loading job I use FME if I have it available or GDAL (

  • 3. Re: shp2sdo
    don123 Newbie
    Currently Being Moderated
    Thanks John.

    I have tried sql developer georapter, only disadvantage is i could not append new records to existing table.
    I have also tried mapbuilder, only one shape file can be loaded at once.
    I need to explore FME and GDAL.
    Is GDAL free to download, Is it OS level utility, can you elaborate further ?

  • 4. Re: shp2sdo
    Stefan Jager Journeyer
    Currently Being Moderated
    Hi Don,

    check the link John gave you, it gives you all the information you need. If you need to do this import regularly, it is a good option since it's command line driven. Which means you can use batch- or command scripts to run it whenever needed.

    FME is extremely powerfull, but comes at a price (proprietary software). it's really great for large ETL's that you need to execute often.

  • 5. Re: shp2sdo
    don123 Newbie
    Currently Being Moderated

    i have checked the link.
    do i need to download oracle spatial driver, i dont see any link to download, is there any documentation on how to use this driver ?
    not clear what to download, how to proceed ?

  • 6. Re: shp2sdo
    Stefan Jager Journeyer
    Currently Being Moderated
    You checked the link but did not explore that website any further? There's a wealth of information there, just go back to the root and start reading. In your case you need the [url]OGR Library.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points