Using Oracle non spatial data

[Anonymous]

HI

Can anybody  give some advice how to create view(sample SQL sentence)   from Oracle database so it tables can be used with Infrastructure server using FDO or ODBC connection.  If database data is non spatial, can this also be done with FDO connection or I must to use ODBC connection. Does non spatial and spatial Oracle data both views are created same way or there are some different ways for creating views.

Thanks for any help.

[gluckett]

If you are using the FDO defined Schema that AutoCAD Map 3D creates, you will notice all the F_ tables in your Oracle database.  You could modify those definitions to accomodate your views. 

An easier solution is to create a new User and use that Schema for your views.  For example, if you have a Schema called GIS_CITY that contains all your data pushed from AutoCAD Map, you may want to create a schema called AIMS_CITY that contains the views you want to look at (do this manually do not use Map 3D to make this).

Once you have done that, within Studio create  a new Data Connection choosing the Autodesk FDO Provider for Oracle.

Log into the AIMS_CITY schema and because there are no F_ tables in that schema you can see all your views etc.

To make your view "selectable" in MapGuide or AIMS you may have to create a Constraint (thanks for this Bruno!):

alter view <viewname> add constraint <constraintname> primary key (<columnlist>) disable novalidate;

http://osgeo-org.1803224.n2.nabble.com/Oracle-FDO-and-View-td1811392.html#a2992905

regards

gordon