Import problem with dblink

[bensmail]

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

[davey23uk]

you need to create the dblink and ensure the tns entry is set up for it

[LKBrwn_DBA]

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:

create public database link LNK_DBNAREF
      connect to myschema identified by mypassword
        using this_database;

[davey23uk]

except the error is cannot resove service name - so the tns entry hasnt been setup

[gandolf989]

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.