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