|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | GISList: Error Oracle 817 |
| Date: |
02/25/2002 07:50:05 AM |
| From: |
Lichte, Jan Willem van der |
|
|
Hello all,
The sql statement made in Oracle 817, gives error messages after retrieving
a couple of rows.
Has anyone got any idea?
column adresvoluit format A50
select /*+ ordered */
b.id
, a.adresvoluit
, (sdo_geom.sdo_distance(b.spatialline, a.coordgeocodepoint,
0.0000005)/1000) Afstand
from adrescyclus a
, gbkt_abri b
where sdo_nn(b.spatialline, a.coordgeocodepoint, 'sdo_num_res=1') = 'TRUE'
and a.adresvoluit like 'PIUS%':
ERROR:
ORA-29902: Fout bij uitvoering van ODCIIndexStart()-routine.
ORA-13203: Lezen van tabel USER_SDO_GEOM_METADATA is mislukt.
ORA-13203: Lezen van tabel USER_SDO_GEOM_METADATA is mislukt.
ORA-29400: Fout van gegevenscartridge.
ORA-01555: Rollback-segment 3 is te klein "RBS2" (snapshot is te oud).
.
ORA-06512: in "MDSYS.SDO_INDEX_METHOD", regel 84
ORA-06512: in regel 1
150 rijen zijn geselecteerd.
Thanks,
Jan Willem van der Lichte
(013) 542 92 03
To unsubscribe, write to gislist-unsubscribe@geocomm.com
________________________________________________________________________
Setup a GeoCommunity Account and have access to FAST DataDownloads
and Premium Career Posting at a discounted rate!
https://www.geocomm.com/cgi-bin/accounts/login
On-line Archives available at
http://spatialnews.geocomm.com/community/lists/
|
|
Sponsored by:
For information
regarding
advertising rates
Click Here!
|
