I have a question as to whether this is possible. I have a table (A) in one Oracle database (1) that is non-geospatial data (no geodatabase) but contains street addresses. This table is constantly being updated with new records.
I have a geodatabase in another Oracle database (2) running ArcSDE 9.3 SP1.
I want to create an SDE view (sdetable -o create_view) to table A resulting in sdeview B which is then geocoded against my address locators within an ArcMap document and used to create a dynamic feature class in the geodatabase (Oracle database 2). In theory as new records are added to table A, they should appear in view B and then be dynamically geocoded and display on my map (assuming a valid street address).
I can create the dblink between the 2 databases just fine and, using standard SQL tools, query records from table A. I can successfully create and register the sdeview using the sde command line tools. I can successfully geocode to a dynamic feature class the records from view B. However, it doesn't appear to be acting "dynamic". I add a new record in table A in database 1, it appears in the sdeview in database 2 but, even though it is a valid and "geocodable" address it does not appear in my point dynamic feature class.
Suggestions or thoughts?