Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.0.5 and database links
A copy of this was sent to dbaoracle_at_aol.com (DBAOracle)
(if that email address didn't require changing)
On 28 Jul 1999 07:54:01 GMT, you wrote:
>We have migrated two Oracle databases from 7.3 to 8.0.5.1. Unfortunatly the
>database links in the newly migrated databases no longer work (these links
>point back to other 7.3 databases). I can create links to other 805 databases
>with no problem. I've also tested building the same link in 8.0.4.3 and it
>appears to work fine. Oracle 8.1.5 gives the same failure.
>
>I've worked with Oracle support for two days, and I am certain this is a bug,
>has anyone found a work around they would like to share please? I have also
>tried to create a new 8.0.5 database and the links still don't work (so this
>isn't a migration issue).
>
>Robert
can you give us more information (OS, version of OS, error message -- anything)
You say it does not work with 8.1.5 (i don't have an 8.0.5 instance handy to test with) but:
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
SQL> create database link oracle73.world using 'oracle73.world'; Database link created.
SQL> select * from dual_at_oracle73.world;
D
-
X
SQL> select * from v$version_at_oracle73.world;
BANNER
SQL> select * from v$version;
BANNER
SQL>
--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Jul 28 1999 - 07:06:16 CDT