AnsweredAssumed Answered

Percentage Sign Appears in My Table Name on Join

Question asked by Matthew.Ryan on Nov 17, 2014
Latest reply on Nov 17, 2014 by fimpe001

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

Outcomes