Settings on the Foreign Schema Instance
Foreign Schema Settings
Read-Write Privileges
Oracle Identity Property
When specifying the main identifier for a feature class with FDO Provider for Oracle, the data type must be Int64. It must also have the following settings: ReadOnly=True and Autogenerated=True. If an identifier is not created with these properties, it will be created by FDO Provider for Oracle. Otherwise, an exception may be raised in certain conditions.
If the foreign schema uses a different data type for identifiers, the user must define the identifier as a fdo int64 type with ReadOnly=True and Autogenerated=True in the XML configuration file. If the identifier in the foreign schema uses an Oracle sequence to generate the unique numbers, the sequencename override must be defined in the override XML file.