Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Red face Unanswered: database links - unable to drop

    Hello,

    The following are the results from queries:

    Logged in like DBA authority user: CHSSS and queried:

    SQL> select * from user_db_links;

    no rows selected

    SQL>

    Logged in like sysdba and the same query gave results as
    SQL> select username,db_link,owner from dba_db_links;

    USERNAME
    ------------------------------
    DB_LINK
    --------------------------------------------------------------------------------
    OWNER
    ------------------------------
    CHSSS
    HISTORY
    PUBLIC

    CHSSS
    MMTEST
    PUBLIC

    When I issue command:
    SQL> drop public database link HISTORY;
    drop public database link HISTORY
    *
    ERROR at line 1:
    ORA-02024: database link not found

    Tried command without public keyword but the same issue of not found.
    How do I drop this link. That link is creating problem in my application.
    Any help is appreciated.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    What happens if you do something like this:[code]SQL> connect chsss
    SQL> drop public database link history;[/codeg

  3. #3
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Wink Thanks for the repy and

    when i login like CHSSS and execute
    drop public database link history

    it says no database link found.

    Does the same with keyword public or without it.

    Any other ideas?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •