This problem is resolved with Database Access 2.1f (ArcSDE 9.0 release.)Internal publish only!
This article may contain sensitive material that is not intended for external circulation.Joined database themes error when zooming in or out if the SDE database is Oracle, Informix or DB2 and the joined table is registered with the geodatabase.
Database Access sends a query to the database that doesn't fully qualify the objectid column. Since both tables in the join have an objectid column, the error appears.
Get help from ArcGIS experts
Download the Esri Support App