<span id="title">SQL Optimizer prompting for bind variable on table alias of DBLink</span>.</p (4285198)

I created a DBLink to a SQL Server database and send a query to SQL Optimizer with a table alias pointing to the table reference by the DBLink. 

For example,
   SELECT * FROM accountstemp@MYSQLSERVERDBLINK.US.ORACLE.COM TT WHERE tt.CreateUserID = 1154;

When I tried to optimize the query, SQL Optimizer will always prompt for bind variable on the columns that the table alias references, (e.g. tt.CreateUserID).   

WORKAROUND:
None

STATUS:
Enhancement request has been submitted to Development for consideration in a future release of SQL Optimizer.