Hi All,
I have a Bentley Water GSA project with all the Oracle based features I want to maintain defined and working properly. But I want to add or include several other reference features which are also within the same Oracle schema, but I don't want the user to be able to maintain (read-only features).
When I open the Oracle connection once my GSA project is loaded, I don't see the tables that are not defined within the GSA project.
I am using Bentley Water 08.11.07.120 for this project.
Any Ideas??
Cheers Ian
Hi Ian. Can you give more details on those additional tables in Oracle ? Have they always been present or have they been added to Oracle after you did your first registrations ? Have you verified that they have a correct sdo metadata record, primary key and so on ? Are they owned by another Oracle user ?
Martin
Ian,
A couple of approaches come to mind.
You could register those additional Oracle Spatial features in the Bentley Geospatial Administrator as you would normally do with the exception of assigning a sequence generater to the layer. By skipping that step you are effectively creating a "read/only" layer from which your users could query spatial feature instances, but would be prevented from posting changes back to your Oracle Spatial repository.
Alternatively, using the Interoperability application, you could create an ad-hoc Oracle Spatial connection, select the layers you wish to query, set symbology etc... then save those settings using "Save As DGN..." command into an Oracle design file, which can then be attached as a reference file.
Regards,
Jeff Bielefeld [Bentley]
Hi Martin,
I have only recently added the layers (which are a view from 2 other schemas). I have added the SDO metadata and I can download them with an adhoc connection. The views are owned by the schema owner.
They are not part of the initial load to Oracle.
Thanks Jeff
I think I will try your second approach. I was trying to do this with Safe FME yesterday, but found that it doesn't support XFM features. So I want to find a way I can automate this process.
If you have any ideas on how I can automate this, I would appreciate it.
Because it is a Bentley Water GSA model, I am trying not to modify the GSA model itself.