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



Oracle LazyDBA home page