Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: db link solution
Simon Cunningham <cs40_at_gre.ac.uk> wrote in message news:<3C512EBB.1070205_at_gre.ac.uk>...
> Content-Type: text/plain; charset=us-ascii; format=flowed
> Content-Transfer-Encoding: 7bit
>
> DB is 817 on NT 4 on both machines
> client on win2k
>
>
> Bug 703020, which mostly reports problems when the dblink name contains
> an '@' and '.' characters, is fixed in 8.1.7.2. Bug 1282056, which has
> to do with teh use of synonyms, is fixed in Oracle9i. Bug 1509361, which
> has to do with the domain name being a part of the dblink, is fixed in
> Oracle9i.
>
> SIMO>desc time_at_duma
> ERROR:
> ORA-02019: connection description for remote database not found
>
>
> SIMO>select * from time_at_duma;
>
> TIME
> --------
> 07:23 PM
>
> Any ideas???
You can simulate the describe command output by selecting against all_ or dba_tab_columns_at_link for the column_name, data_type, etc....