Re: Export

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 18 Oct 1999 08:34:36 GMT
Message-ID: <380adaaf.14367502@news.demon.nl>

On Mon, 18 Oct 1999 07:13:05 +0200, "K. Lambert" <lambert_at_consilium.de> wrote:

>Hello,
>
>we are running an oracle 8.0.5.0 Server and another oracle 7.3.4.0. To
>export a user from 8 to 7 i
>wish to do a export with exp73 on the ora 8 side. (catexp7.sql is done)
>
>After inserting user and password i get the Message:
>
>ORA-03121: no interface driver connected - function not performed
>
>I need help, what to do!
>
>with regards
>
>Knut Lambert
>(lambert_at_consilium.de)
>
>

I would guess this has to do with sqlnet looking for $ORACLE_HOME|%ORACLE_HOME%/network/admin (If I understand you correctly, you are running exp73 on the Oracle 8 server, right?!) You should either set an environment variable TNS_ADMIN pointing to the NET8 directory (ORACLE_HOME/net8/admin) or copy your tnsnames.ora and sqlnet.ora to the Oracle 7 location. ORA-3121 typically happens when you don't specify a service and there's no default database

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Oct 18 1999 - 03:34:36 CDT