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