REPOST: 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....

• Mark D Powell --
  • WAS CANCELLED BY =======: From: mark.powell_at_eds.com (Mark D Powell) Control: cancel <178d2795.0201250605.3fc3ae50_at_posting.google.com> Subject: cmsg cancel <178d2795.0201250605.3fc3ae50_at_posting.google.com> Date: Mon, 28 Jan 2002 01:56:31 GMT Message-ID: <cancel.178d2795.0201250605.3fc3ae50_at_posting.google.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!blackbush.xlink.net!blackbush.de.kpnqwest.net!news0.de.colt.net!newsfeed.r-kom.de!newsfeed.freenet.de!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40723125

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 08:05:51 CST