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 <*> 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/
