OpenCities Map Forum Only a few tables are visible through Oracle import

Only a few tables are visible through Oracle import

Offline Krister Surell over 13 years ago

Hi, I try to import data from Oracle Spatial but only a few of my tables turns up. The all have one geometry column, one geometry type, spatial indexes with a specified geometry type. It seems that only the tables with a simple primary key (one column) are visable. Is that the case or could it be anything else that filters out some tables? Regards, Krister Surell

Offline Martin Roy Tue, May 11 2010 3:53 PM in reply to Krister Surell
Hi Kirster. Bentley Map effectively does not support compound primary keys at the moment for registered features or ad-hoc Oracle connections. However, you can still read your data using the Interoperability dialog. You can add an "import" entry and choose the "Add Oracle (read-only)" option. This should list your missing tables.

Hope this helps,

Martin
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Offline Krister Surell Wed, May 12 2010 2:41 PM in reply to Martin Roy
Hi Martin,

Thank you for clearing out the difference. Beeing quite new to Bentley Map I just tried the "Open Oracle Spatial" option. The Interoperability dialog works just fine.

Still looking forward to be able to do updates in the future though. Could that be done by creating updatable views with a single, derivated, key?

Regards,

Krister

Owner consultant at Surell Consulting AB
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel