Code Assistant does not work for a Database Link

[rbybee]

Is there a way to enable the Code Assistant so it will show me the columns of a table using a database link? For example, if I type the following select, no columns are displayed when I type the period after the table alias.

select * from fnd_user@prod u
where u.

Thanks.

 

[Marco van der Linden]

I don't think that is possible. If I understand correctly, the code assistant looks at the metadata and it cannot do that over a db link. A workaround would be to create a view for the remote object. The metadata would then be available in the instance you're logged on to.
e.g create view fnd_user_remote as (select * from fnd_user@prod)

 

[BWendling]

Of course it *could* look at the remote metadata, too (all_tab_columns@prod), which I would support strongly. It might degrade performance and should thus be individually configurable.