Hi Everyone,
I'm using ArcMap to join some datasets and one of the datasets is a materialized view. When I do an attribute join it qualifies the name of each table involved so they look like <schema_name>.<table_name>. This is all good if you do a join on two tables but if you join to a view or materialize view the table name looks like <schema_name>.%<table_name>.
Basically it is putting a percentage sign in the table name for some reason. This prevents ANY queries from being done against the table because percentage signs are invalid in table names.
Why is ArcMap changing the table name?
I'm using ArcMap 10.2.2
Oracle 10g
I experienced the same issue, but the cause was likely different (involving oracle 11g and SQL Server tables...can't remember the details right now). My workaround was to use ArcMap querylayers. I believe you create one via File--> Add-->Query layer. Perhaps that is a viable option for you?