| Author |
Message |
Forte Agent
*nix forums beginner
Joined: 15 Dec 2005
Posts: 5
|
 Posted: Thu Jul 13, 2006 1:50 am Post subject:
Database link cannot be dropped
|
|
|
Dumb question . . . . .
I have an Oracle database 10.2.0.2 where I cannot drop database links.
When I do "drop database link XXX", database link named
"XXX.domainname.com" is dropped, but not "XXX". What should I do?
Thank you in advance. |
|
| Back to top |
|
 |
gazzag
*nix forums Guru Wannabe
Joined: 08 Jun 2005
Posts: 277
|
| Posted: Thu Jul 13, 2006 9:45 am Post subject:
Re: Database link cannot be dropped
|
|
|
Forte Agent wrote:
| Quote: | Dumb question . . . . .
I have an Oracle database 10.2.0.2 where I cannot drop database links.
When I do "drop database link XXX", database link named
"XXX.domainname.com" is dropped, but not "XXX". What should I do?
Thank you in advance.
|
What do you get from the following query?
SELECT * FROM DBA_DB_LINKS;
Additionally, post your sqlnet.ora file so we can see that.
HTH
-g |
|
| Back to top |
|
|
Mark D Powell
*nix forums Guru
Joined: 23 Apr 2005
Posts: 701
|
| Posted: Thu Jul 13, 2006 1:54 pm Post subject:
Re: Database link cannot be dropped
|
|
|
gazzag wrote:
| Quote: | Forte Agent wrote:
Dumb question . . . . .
I have an Oracle database 10.2.0.2 where I cannot drop database links.
When I do "drop database link XXX", database link named
"XXX.domainname.com" is dropped, but not "XXX". What should I do?
Thank you in advance.
What do you get from the following query?
SELECT * FROM DBA_DB_LINKS;
Additionally, post your sqlnet.ora file so we can see that.
HTH
|
Forte, the DDL you posted would drop a private database link owned by
the connected Oracle username. Who does the link you are trying to
drop belong to? The query gazzag posted will provide the necessary
information.
drop public database link xxx.whatever;
HTH -- Mark D Powell -- |
|
| Back to top |
|
|
Forte Agent
*nix forums beginner
Joined: 15 Dec 2005
Posts: 5
|
| Posted: Wed Jul 19, 2006 8:13 pm Post subject:
Re: Database link cannot be dropped
|
|
|
Thank you all for help. My SQLNET.ORA has followings only:
NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10
Output from DBA_DB_LINKS is below:
OWNER DB_LINK USERNAME HOST CREATED
------------------------ -------- ------- -------------------
USER1 TESTDB5.DOMAIN.COM USER1 testdb5 15-06-2006 10:58:02
USER1 TESTDB5 USER1 testdb5 25-05-2006 21:37:32
USER2 DBLINK1.DOMAIN.COM USER3 devdb1 15-06-2006 11:06:25
USER2 DBLINK1 USER3 proddb1 20-02-2002 09:05:39
On 13 Jul 2006 06:54:23 -0700, "Mark D Powell" <Mark.Powell@eds.com>
wrote:
| Quote: |
gazzag wrote:
Forte Agent wrote:
Dumb question . . . . .
I have an Oracle database 10.2.0.2 where I cannot drop database links.
When I do "drop database link XXX", database link named
"XXX.domainname.com" is dropped, but not "XXX". What should I do?
Thank you in advance.
What do you get from the following query?
SELECT * FROM DBA_DB_LINKS;
Additionally, post your sqlnet.ora file so we can see that.
HTH
Forte, the DDL you posted would drop a private database link owned by
the connected Oracle username. Who does the link you are trying to
drop belong to? The query gazzag posted will provide the necessary
information.
drop public database link xxx.whatever;
HTH -- Mark D Powell -- |
|
|
| Back to top |
|
|
Anurag Varma
*nix forums Guru Wannabe
Joined: 25 Mar 2005
Posts: 194
|
| Posted: Thu Jul 20, 2006 9:29 pm Post subject:
Re: Database link cannot be dropped
|
|
|
Forte Agent wrote:
| Quote: | Dumb question . . . . .
I have an Oracle database 10.2.0.2 where I cannot drop database links.
When I do "drop database link XXX", database link named
"XXX.domainname.com" is dropped, but not "XXX". What should I do?
Thank you in advance.
|
You might have global_names = true and have a domain specified.
You might need to set global_names to false to accomplish what you
are doing (However, understand the replication repurcussions of doing
that).
Anurag |
|
| Back to top |
|
|
Brian Peasland
*nix forums Guru
Joined: 04 Apr 2006
Posts: 301
|
| Posted: Thu Jul 20, 2006 10:19 pm Post subject:
Re: Database link cannot be dropped
|
|
|
Anurag Varma wrote:
| Quote: | Forte Agent wrote:
Dumb question . . . . .
I have an Oracle database 10.2.0.2 where I cannot drop database links.
When I do "drop database link XXX", database link named
"XXX.domainname.com" is dropped, but not "XXX". What should I do?
Thank you in advance.
You might have global_names = true and have a domain specified.
You might need to set global_names to false to accomplish what you
are doing (However, understand the replication repurcussions of doing
that).
Anurag
|
It may be worth a try, but did you enclose the link name in double quotes?
DROP DATABASE LINK "XXX";
It might not work, but it's worth a shot...
Cheers,
Brian
--
===================================================================
Brian Peasland
dba@nospam.peasland.net
http://www.peasland.net
Remove the "nospam." from the email address to email me.
"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
»
Server
