Re: Database link from 8i to 7.3.3

I have a link from a 7.3.4 to an 8.0.5 and one from an 8i ( 8.1.5) to a 7.3.4 and they work fine...The syntax for v8 is different - the link name MUST be the same as the TNSNAMES.ORA alias, so if
your ORCL instance is set as myorcl.world in tnsnames the DB Link must be named myorcl.world

Also remember, the tnsnames.ora file on the server where your database is located is the one used to resolve links not the one on the client...

Hope it helps,
John Greco

Mike Mountjoy <mike_at_london.virgin.net> wrote:

>In general database links , triggers and so on do not work where the source
>version of
>the database is higher than the destination.
>
>Hence a trigger on a 7.3.3 db to an 8i db will always fail. The other way
>round
>works fine.
>
>
>gwellman_at_my-deja.com wrote:
>
>> On my Oracle 8i box, I used the Net8 assistant to create a net service
>> name (ORCL) that points to an Oracle 7.3.3 database (with sid 'ORCL')
>> on another box. I tested the net service name there and it worked.
>> (Aside: the 8i net service name is 'ORC8' so there's no conflict there.)
>>
>> Logged on to Oracle 8i (in SQL+) I entered:
>>
>> create public database link orc7 connect to current_user using 'ORCL';
>>
>> and it said "database link created"
>>
>> but when I try
>>
>> select * from schemaname.tablename_at_orc7;
>>
>> after a long pause, I get
>>
>> ORA-00600: internal error code, arguments: [kspgsp2], [91184288], [265],
>> [ent_domain_name], [0], [1], [], []
>>
>> I'm pretty sure the problem has nothing to do with "current_user"
>> because I've tried it with several users who exist on both systems.
>>
>> Any help greatly appreciated.
>>
>> Thanks,
>> Greg
>>
>> PS: Both Oracle boxes are WinNT.
>>
>> PPS: The *reason* I'm making the db link is because I want to be able
>> to copy data from the 7.3.3 machine to the 8i machine. I want to change
>> the tablespace assignments of the objects I'm copying, otherwise I'd
>> just use the export utility. If I can't get the database link to work,
>> does anyone have any suggestions to accomplish the underlying goal?
>>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Tue Nov 09 1999 - 10:53:49 CST