4 Replies Latest reply: Mar 18, 2010 2:40 AM by 760779 RSS

    Building floor plans ESRI shape files generated from autocad

    760779
      Hi,

      I'm trying to import a shape file that was generated with Autocad Map from a building floor plan in DWG file. When importing the file I get the following error

      Connecting to Oracle10g using...
      localhost, 1521, mvdemo, mvdemo, mvdemo, kenai, kenai2, null, 0
      Dropping old table...
      java.sql.SQLException: ORA-00942: table or view does not exist

      Creating new table...
      java.sql.SQLException: ORA-00904: : invalid identifier

      java.sql.SQLException: ORA-00942: table or view does not exist

      Record #1 not converted.
      java.sql.SQLException: ORA-00942: table or view does not exist

      I explore the dbf file generated for the shapefile and this are the fields on the table:

      ANGLE
      AREA
      BULGE
      CENTER
      CENTROID
      COLOR
      DWGNAME
      EANGLE
      EHANDLE
      ELEVATION
      EWIDTH
      HEIGHT
      LABELPT
      LAYER
      LENGTH
      LINETYPE
      LINEWEIGHT
      LOCKSTAT
      PLOTSTYLE
      RADIUS
      ROTATION
      SANGLE
      SIZE
      SWIDTH
      TAG
      THICKNESS
      TRUECOLOR
      TYPE
      URL
      X1
      Y1
      X2
      Y2
      X3
      Y3
      X4
      Y4
      XSCALE
      YSCALE

      So far I has been unable to indentify the field which has the invalid identifie, I have check with Oracle reserved words as well. Can please someone advise? Also, has been anyone successfull using mapviewer to represent building planes?

      Best,

      Susana