Hello, Kornel:
I thought you were talking about Oracle Spatial, but now I see your table is an
alphanumeric one. I do not know in detail how the gvSIG alphanumeric Oracle
driver works, sorry.
However, I have succesfully exported the table to SHP after creating another
view which leaves out the OBJEKT_ID field:
CREATE VIEW TEST_AUS_VIEW_V ("NAME", "STRASSEHAUSNR", "PLZ", "ORT",
"ANNOTATIONO", "Y", "X") AS SELECT "NAME", STRASSEHAUSNR, PLZ, ORT,
ANNOTATIONO, Y, X FROM TEST_AUS_VIEW;
Then repeat the same process you did, but using TEST_AUS_VIEW_V as the table
name. I have obtained a 1.5-megabyte DBF file. The string fields are cropped to
254 characters (possibly a DBF limitation)
If your database is an Oracle Spatial or Locator database, there might be other
ways to do this without renouncing to the OBJEKT_ID field, but I don't know if
the 254-character limit in DBF files can be avoided. Is it an Oracle Spatial DB
or a traditional alphanumeric Oracle DB?
***
Apart from that: the parameters for the public Oracle Spatial DB have changed,
now the port is 80, so maybe you will be able to access it too from your
restricted network:
URL: lucasdom.homelinux.org
Port: 80
DB name: xe
User: gvsig
Password: gvsig
Regards,
Juan Lucas Domínguez Rubio
---
Prodevelop SL, Valencia (España)
Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
http://www.prodevelop.es <http://www.prodevelop.es/>
---
________________________________
De: [email protected] en nombre de K.Kiss
Enviado el: mar 14/12/2010 17:00
Para: [email protected]
Asunto: Re: [Gvsig_english] Oracle spatial, field length different after
exporting to shapefile
Hello,
I have a similar problem. Briefly described:
A Oracle View has originally a field of the type Varchar2 with 4000 byte.
If I try into gvSIG (table is loaded and with X/Y - coordinates provide) the
table as Shape to export.
The presentation was ok.
It comes to export errors. 0bytes written
>From the memory (the error-entry): "invalid field type 2 (DBF export)" !
If i shorten the Varchar2 to 255 byte, the problem does not exists....
Greetings
Kornel Kiss
-----
Kornel Kiss
Referat für Gesundheit und Umwelt
Anforderungsmanagement Fachanwendungen
Bayerstr. 28a
80335 München
--
View this message in context:
http://osgeo-org.1803224.n2.nabble.com/Oracle-spatial-field-length-different-after-exporting-to-shapefile-tp5812040p5834434.html
Sent from the gvSIG international mailing list archive at Nabble.com.
_______________________________________________
Gvsig_internacional mailing list
[email protected]
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
_______________________________________________
Gvsig_internacional mailing list
[email protected]
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
