Skip to main content
Question

Write data to a new column in an Enterprise Geodatabase in Oracle:

  • October 30, 2019
  • 2 replies
  • 13 views

jhawks
Contributor
Forum|alt.badge.img+7

If I create a new column in a feature class and want to write data to it, is is "Insert and Create as Needed" in the General Table Operations?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

runneals
Supporter
Forum|alt.badge.img+28
  • Supporter
  • October 30, 2019

Create if needed will use the existing table if one already exists with the same table name, otherwise it will create a new one. So you shouldn't have to worry about those settings. Are you reloading the data? If so, you might want to try truncating it. I personally like to import the settings from the existing table, so all the lengths and types come through correctly, but that's just me.


itay
Supporter
Forum|alt.badge.img+18
  • Supporter
  • October 31, 2019

That depends if you want to insert new records into the table (below the existing records) or empty the table and insert all records again (truncate option).

As mentioned you should see the changes (additional column) after updating the feature type (Writers menu > Update Feature Types) if changes are made outside of FME and need to be introduced.