Import problem with dblink
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Import problem with dblink

  1. #1
    Join Date
    Mar 2002
    Posts
    301

    Import problem with dblink

    I got a import problem for a schema package containing a dblink.
    The package is wrapped.
    After import only package specification is created and the package body not.

    DB: Oracle 9i
    error Message:

    package body PKG_COMMUN_OPERATIONS_TABLES wrapped
    IMP-00003: ORACLE error 4052 encountered
    ORA-04052: error occurred when looking up remote object OPS$DBNAD.MPD_COLN@LNK_DBNAREF
    ORA-00604: error occurred at recursive SQL level 1
    ORA-12154: TNS:could not resolve service name.

    How can I correct the problem?
    In my database I don't have target database for this dblink.

    Bensmail

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you need to create the dblink and ensure the tns entry is set up for it

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,478

    Talking Dummy db link

    Maybe that package is not needed for your database.

    Otherwise you can temporarily create a dummy dblink to the same database you are importing and then figure out what to do:

    Code:
    create public database link LNK_DBNAREF
          connect to myschema identified by mypassword
            using this_database;
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    except the error is cannot resove service name - so the tns entry hasnt been setup

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,003
    So the package fell out of the sky and no one knows what kind of dblink needs to be created? How will you know what schema to connect to and what objects need to exist on the other side? you should go back to the person who gave you the import and get better instructions.
    this space intentionally left blank

Posting Permissions

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



Click Here to Expand Forum to Full Width