One way would be to install new XE instance, copy tables (e.g. 1 row) one by one and try to isolate table which is causing problems. Then you could use desc or some other way , depending on tools you are using, to send me SQL which creates that table. Haris
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of born2bwild Sent: Monday, December 08, 2008 8:51 PM To: mapguide-users@lists.osgeo.org Subject: RE: [mapguide-users] New King.Oracle 0.8 - improved performance Hi and thanks a lot, I don't use KingFdoClass. I always use OracleSchema connection property, but I tried without : same problem. I've tried with the same owner and other owner with full Oracle privilege (DBA) : same problem. I've tried with Oracle 9i and 10g (locator, not spatial) : same problem. Finaly I've tried to activate SQL Trace on both oracle database, to isolate the problem, but I didn't see anything (I can send you thoses traces for help). How can I send you (email) sql, schema and oaner describtions to recreate the problem ? Haris Kurtagic wrote: > > Hi, > > It looks like King.Oracle 0.8.x has problems in DescribeSchema in some > cases. > I will try to solve in next couple of days. > Your input could help me to faster find point of error. > Do you use KinfFdoClass table ? > Do you use OracleSchema connection property (to use tables from only one > owner) ? > And if so is it same owner as the username you use to connect to > database ? > You already told so, but to recheck it is same for 9.2 and 10g ? > > If you could isolate problem to one particular table and send me SQL to > recreate that table, that could help. > > Thanks, > Haris > > > > -- View this message in context: http://n2.nabble.com/New-King.Oracle-0.8---improved-performance-tp151912 0p1630603.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users