Ok, I understand that. So, how about this: In your FME translation, are you referencing the table as LANDBASE_MAIN.PARCEL, or just PARCEL? If you have created a public synonym, you don't need to reference the schema owner LANDBASE_MAIN. It's possible, though I don't know for sure, that FME can't handle the schema owner prefix, and substitutes the '_' of the '.' Try this:
1. In SQL*Plus, log into Oracle as your update user and describe the table. This is the command: desc PARCEL If you are able to do that, your update user can see the table via the public synonym. (Forgive me if this is too much detail) 2. Attempt to insert a row into the PARCEL table. This will tell you if your update user has all the access it needs. Don't forget to issue a rollback. Now you have eliminated any database issues and can focus on FME. 3. In your FME translation, make sure you indicate that the table already exists. I'm not looking at FME right now but it's a setting in the last tab of the target. 4. Have you created a metadata entry for the table in Oracle to register the spatial column in the PARCEL table? FME looks at the metadata entries to come up with its list of possible target tables in the database. You can write to a non registered table, but it might help to register it if you haven't. 5. Drop the schema owner reference from your target and refer to the table simply as PARCEL. I hope this helps. --Scott -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Smart Sent: Tuesday, November 22, 2005 4:10 PM To: [email protected] Subject: [fme] Re: FME Creates new Oracle table as current user Hi Scott, sorry for the confussion the oracle users are named "LANDBASE_UPDATE" and "LANDBASE_MAIN". So I have a table LANDBASE_MAIN.PARCEL -- When I run the load as user "LANDBASE_MAIN" it works fine. But our DBA wants us to use another user (without DROP or CREATE table priv.) to load the data. -- When I run the translation as user "LANDBASE_UPDATE" FME does not appear to be able to see the table and tries to create a new table called "LANBASE_MAIN_PARCEL" (note the "_" between table owner and tablename). regards Matthew --- In [email protected], "Scott Wilger" <[EMAIL PROTECTED]> wrote: > > Matthew, > > I don't know this for sure, but you may be having trouble because you > named your user UPDATE. This is definitely a reserved word in Oracle, > and I'm a little surprised that you were able to create a user with that > name. Try creating a user with a different name, grant the same > privileges, and give it another shot. Just an idea, > > Scott Wilger > Denver, CO USA > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of > Matthew Smart > Sent: Sunday, November 20, 2005 6:35 PM > To: [email protected] > Subject: [fme] FME Creates new Oracle table as current user > > I have created a number of oracle tables under the oracle > username "MAIN" and created public synonyms for them. I then granted > another user "UPDATE" with Select, update, insert privlidges to > these. When FME trys to load data as the UPDATE user it seems to look > for a table under the current username e.g. UPDATE.PARCEL, and when it > finds this doesn't exist it tries to create it. The UPDATE user does > not have permission to create tables. If I add the table owner to the > FME source dataset definition it puts a "_" rather than a "." between > the oracle username and the table and gets "MAIN_PARCEL", and as this > doesn't exist it, once again, tries to create a new table > UPDATE.MAIN_PARCEL. > > Why does it use "_" between Oracle user and table name? Is there a > setting for this? > > regards > Matthew Smart > Brisbane Australia > > > > > > > > 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 > 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 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/
