Roman Rokytskyy wrote:

>> And I don't see big problem with absence of metadata of foreign objects.
>> AFAIU, Oracle also doesn't store it.
>>
>
> Are you talking about the fact that one does not need to declare
> particular external table or about the absence of the information about
> the external tables via the connectivity components?

1) No need to declare external table - just declare the data source
(dblink) and use it.
2) The information we have in SQLDA and more columns to schema and
dblink name is sufficient
3) We don't need to have foreign metadata in our system tables

And if we really want to return metadata of foreign tables, we can
implement information schema (as views) that query our system tables
more system tables of foreign databases (though the provider).


Adriano