This discussion is archived
4 Replies Latest reply: Mar 18, 2010 12:40 AM by 760779 RSS

Building floor plans ESRI shape files generated from autocad

760779 Newbie
Currently Being Moderated
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

Legend

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