I have a feature class with a property that is out of sync with the database table. The field property is "Allow NULL values" and it's currently set to "No". Earlier today, before I was aware of this setting in the feature class field properties, I deleted the "IS NOT NULL" constraint on the database table. The database table says this column should accept NULL values but the FC, when viewing in ArcMap, says NULL values are not allowed.

How do I synchronize the FC and database? Is there a metadata table somewhere that needs to be refreshed? Is there a better way to change the field property?

  • 1
    What database are you using? Removing the constraint may not change the the database's NOT NULL setting. – Vince Feb 25 '15 at 21:23
  • @Vince Oracle 11g... – DenaliHardtail Feb 25 '15 at 21:25
  • I think GDB_FieldInfo also has these constraints listed, that may be SDE_FieldInfo or similar. I would back up your database before mucking around in the back end, it's too easy to cause irreparable damage. – Michael Stimson Feb 25 '15 at 21:36
  • 1
    Please edit the question to include the exact Oracle release. – Vince Feb 25 '15 at 21:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.