Hello Sharon, Did you make sure that your spatial tables are registered as spatial? ie do you have an entry for each spatial table in the USER_SDO_GEOM_METADATA view? Also make sure that the user, you are using in the FMEviewer, has enough rights to read the MDSYS.USER_SDO_GEOM_METADATA and MDSYS.ALL_SDO_GEOM_METADATA views.
Harm --- In [email protected], "oidhche_uk" <[EMAIL PROTECTED]> wrote: > Hi, > > I am a complete beginner at FME and am having trouble finding a > solution to a problem which I'm sure others must have encountered. > > I am trying to specify an Oracle 9i spatial database as my data > source in FME Universal Viewer. I select the Oracle 10g/9i/8i > Spatial (Object) option from the Formats Gallery, then click on > Settings to select the data source. I enter the username, password > and service (ORACLE_SID) in the appropriate fields, then click the > ellipse button next to the Table List field to show the tables in > the database. > > This doesn't work: I get the error message > > The below command line failed to execute: > ora8list -allusers -object "RLR" "username" "password" C:\DOCUME~1 > \m159279\LOCALS~1\Temp\fme73.tmp > > I have gone into the FME Suite directory and used the ora8list > command, with literally no results - no table lists are returned, no > error messages are displayed. > > I know this is probably a very basic question but I haven't been > able to find an answer in the archives (although I may have been > looking for the wrong thing). How do I get FME to access the > database? I am using FME 2005(20050607 - Build 1696). > > Many thanks for any help, > > Sharon Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
