| Problem with .WORLD in DB links [message #221912] |
Thu, 01 March 2007 00:44  |
shahul_555
Messages: 4
Registered: February 2007
Location: India
|
Junior Member |
|
|
Hi all,
I migrated the database from 8i to 10g. DB links which were in 8i were not created in 10g after IMPORT so I had to create it manually using scripts. DB links in 8i were in the format DB_linkname.WORLD ie., SINT.WORLD,HSDL.WORLD etc. I created the same in 10g. Now the problem is in accessing the DB links.
select * from dual@SINT;
This workds in 8i but not in 10g. Only if I give SINT.WORLD in 10g it is working. ie., select * from dual@SINT.WORLD;
Why is this happening? I cannot remove .WORLD from all the procedures and packages which uses DB links. So please suggest me a good solution. Thanks.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Problem with .WORLD in DB links [message #223627 is a reply to message #221912] |
Fri, 09 March 2007 19:10  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
There are several things that do not live through export/import. I think db links are one of them.
I would also recommend you check that the following is valid.
your functions
your procedures
your packages
triggers
views
And the same owned by sys and system
Sometimes if you recompile these a few times they become valid. This is due to dependency.
You will probably have to drop and recreate your links. Make sure your links have a user/password on the remote db and your links has the correct passwords.
[Updated on: Fri, 09 March 2007 19:12] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
