Go to OEM, find drop database link button, click on button, have a red stripe!

-----Original Message-----
From: Yang Yanyan (JSC-OH230)[ARES] [mailto:oracledba-ezmlmshield-x76184310.[Email address protected]
Sent: Thursday, January 31, 2008 11:41 AM
To: LazyDBA Discussion
Subject: RE: Drop db link

Thanks. But it is not public link.

-----Original Message-----
From: Israel Laureano Lazcano [mailto:oracledba-ezmlmshield-x13895359.[Email address protected]
Sent: Thursday, January 31, 2008 11:24 AM
To: LazyDBA Discussion
Subject: Re: Drop db link

Maybe it's a public link. Try:

drop public database link FSPRD;

Israel.

Yang Yanyan (JSC-OH230)[ARES] escribió:

>This what I did: Login as the db link owner sysadm and drop the link.
>
>SQL> drop database link FSPRD;
>drop database link FSPRD
> *
>ERROR at line 1:
>ORA-02024: database link not found
>
>Do you think is it something related to the global name? Do I need to
>update props$ table for the global name? Any other suggestion?
>
>Thanks
>Yanyan
>
>-----Original Message-----
>From: Lawrence Traub
>[mailto:oracledba-ezmlmshield-x89733185.[Email address protected]
>Sent: Thursday, January 31, 2008 11:04 AM
>To: LazyDBA Discussion
>Subject: RE: Drop db link
>
>
>To me it looks like sysadm owns the link. Try this:
>
>DROP DATABASE LINK sysadm.fsprd ;
>
>Or log in as sysadm and drop the link as normal.
>
>Regards,
>
>Lawrence Traub, DBA
>
>-----Original Message-----
>From: Yang Yanyan (JSC-OH230)[ARES]
>[mailto:oracledba-ezmlmshield-x47775797.[Email address protected]
>Sent: Thursday, January 31, 2008 10:52 AM
>To: LazyDBA Discussion
>Subject: Drop db link
>
>Hello,
>
>Can anyone help on this problem? I am trying to drop a database link
>and received the error message.
>
>SQL> sho user
>USER is "SYSADM"
>SQL> select * from user_db_links;
>
>DB_LINK USERNAME PASSWORD
>HOST CREATED
>-------------------- ------------------------------
>------------------------------ -------------------- ---------
>FSPRD SYSADM BLUESKY
>FSPRD 12-DEC-05
>
>
>SQL> drop database link FSPRD;
>drop database link FSPRD
> *
>ERROR at line 1:
>ORA-02024: database link not found
>
>SQL> select * from global_name;
>
>GLOBAL_NAME
>-----------------------------------------------------------------------
>-
>------------------------------------------------
>
>HRPRD.WORLD
>
>SQL> sho parameter global
>
>NAME TYPE VALUE
>------------------------------------ -----------
>------------------------------
>global_context_pool_size string
>global_names boolean FALSE
>
>
>Thanks
>
>Yanyan
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
>a dba job: http://jobs.lazydba.com To Subscribe :
>http://www.LazyDBA.com To unsubscribe:
>http://www.lazydba.com/unsubscribe.html
>
>
>
>This message is intended only for the use of the individual(s) or
>entity to which it is addressed and may contain information that is
>privileged, confidential, and/or proprietary to RealPage and its
>affiliated companies. If the reader of this message is not the intended
>recipient, you are hereby notified that any dissemination,
>distribution, forwarding or copying of this communication is prohibited
>without the express permission of the sender. If you have received this
>communication in error, please notify the sender immediately and delete
>the original message.
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
>a dba job: http://jobs.lazydba.com To Subscribe :
>http://www.LazyDBA.com To unsubscribe:
>http://www.lazydba.com/unsubscribe.html
>
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
>a dba job: http://jobs.lazydba.com To Subscribe :
>http://www.LazyDBA.com To unsubscribe:
>http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
>


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


***************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally
privileged.

If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank You.
****************************************************************************


Oracle LazyDBA home page