Hi Hans Erik
This might solve it (looks weard but it did it for me, got it from
MapInfo and it comes from Oracle ...):
Here is the workaround for bug 2755842, which I believe will address
MapInfo issues when using Oracle 9.2.0.3.
Workaround for bug 2755842:
Event 10499 can be set (any non-zero level) to revert to the old
behaviour.
==================================================
Setting the EVENT 10499
=======================
Check if the database server is using a server parameter (spfile) a
parameter (init.ora) file.
>From sqlplus, connect as sysdba and execute the command:
show parameters spfile
If the value is NULL or empty, then spfile is NOT enabled and init.ora
is
used.
1) If SPFILE is used:
SQL> show parameters spfile
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
spfile string %ORACLE_HOME%
\DATABASE\SPFILE%ORACLE_SID%.ORA
a) Using sqlplus logon as sysdba
b) Execute: alter system set event="10499 trace name context
forever,level 4" scope=spfile sid='*';
c) shutdown
d) startup the database
2) If INIT.ORA is used:
a) In the init<SID>.ora file, add the parameter event="10499 trace
name
context forever,level 4"
b) Stop and start the database
<Tomc 09/05/03>
I reveived this from our Oracle supprot engineer validating the fix for
the
spatial column error:
I just thought I'd let you know 9.2.0.4 is now out. The fix list is
attached. Please contact me if you have any questions.
The problem of Opening a table containing Oracle Spatial data using
Mapinfo Professional will fail with the following error message:
Unsupported data type for Column(s): {column name} This happens
irrespective of the access mode used ("linked table" or "live access".
This is the same error message given when trying to open a table that
has not been "made mappable", i.e. one for which no definition exists in
the Mapinfo map catalog table.
In 9.2.0.3 and 9.2.0.4 the fix for <Bug:2235818> is needed for
Java-related standards compliance. However, implementing this fix may
cause unexpected behaviour if customers use pre-9.2.0.3 client programs
(Eg, Mapinfo 6.x or 7.0, and Pre 9.2.0.3 SQL*Plus). Oracle has
implemented an event that allows customers to revert to the old
behaviour if they wish to.
event="10499 trace name context forever, level 4"
this gets Mapinfo working again...
Mit freundlichen Gr��en,
Volkmar Kuhnle
Project/ Support Consultant
(Embedded image moved to file:
pic07545.jpg)
Kelsterbacher Stra�e 23
65479 Raunheim
Tel.: +49 6142-203-503
Mobil: +49 163 6 203 503
Fax: +49 6142-203-444
Mail: [EMAIL PROTECTED]
Web: www.mapinfo.de
Anfahrt: Anfahrtsbeschreibung
Mit freundlichem Gruss / Best regards
Flavio Hendry
----------------------------------------------------------------
++++++++++ Neue Neapoljs Seiten auf www.neapoljs.com +++++++++++
----------------------------------------------------------------
############ Mit freundlichen Gruessen / Kind Regards
############ Flavio Hendry- mailto:[EMAIL PROTECTED]
############ TYDAC AG - http://www.tydac.ch
#### #### Geographic Information Solutions
#### #### Luternauweg 12 -- CH-3006 Bern
############ Tel +41 (0)31 368 0180 - Fax +41 (0)31 368 1860
----------------------------------------------------------------
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 8627
