Skip to main content
Question

Update an Oracle table from an Oracle table VIEW...is it possible and how to set it up, please?

  • July 30, 2021
  • 1 reply
  • 5 views
G

I have an FME process that updates one Oracle table from another via a ChanageDetector process. I notified the DBA that the table I am reading from is missing a field. The DBA created a able VIEW with the missing field and advised I use that to update the other table.  I don't see Oracle table VIEWS as an option in the Reader I am using. Can an Oracle table VIEW be used in a Reader? If so, how is that accomplished?

Thanks in advance.

1 reply

geomancer
Evangelist
Forum|alt.badge.img+58
  • geomancerEvangelist
  • Evangelist
  • 932 replies
  • August 2, 2021

Are you reading a spatial view? Then the metadata of the view needs to be defined in MDSYS.SDO_GEOM_METADATA. See here for more info.


Community Stats

32,070
Posts
121,771
Replies
39,696
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.