displaying remote structures in Query Builder

[Wayne Essel]

I have access to a remote schema running on a remote server that I sometimes need to link to the schema/server I am currently developing. When I use the Query Builder to create a join, the fields in the tables in the remote schema/server do not display, even though the query runs OK. Is there a way to:

a. Display the remote tables/fields from the remote server in the object browser?
b. Display fields from tables in the remote schema/server in the Query Builder?

Thanks,

Wayne

 

[Marco Kalter]

Remote tables are currently not supported by the Query Builder. You can use remote tables in your query, but the Query Builder will not describe the table for you.

 

[Wayne Essel]

Drat!

Can you put that in the enhancement list?

W

 

[aotte]

Maybe not ideal for you, but we use synonyms to drive remote access through dblinks, and a synonym would allow you to use the query builder.

Just an idea.

 

[Wayne Essel]

Thanks. I was wondering if that would work. I'll try it and see.