Re: import problem

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Mon, 06 May 2002 16:33:06 +0200
Message-ID: <3CD69422.8060500_at_mytoys.de>

Luca wrote:

>>1st: You export a 8.1.7 database and try to import it in a 8.1.6 database.
>>

> To
> 

[Quoted] >>solve this problem, use the exp utility from your 8.1.6 to do the export.
>>

>
[Quoted] > Only copy command exp in another pc?

NOOOO! Do the export from a 8.1.6 installation, e.g. from the pc where you want [Quoted] to do the import. Imagine you have a tnsnames.ora entry (on the 8.1.6 machine) like

NEWDB.MYDOMAIN.COM =
   (DESCRIPTION =

     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = newhost)(PORT = 1521))
     )
     (CONNECT_DATA =
       (SERVICE_NAME = NEWDB)
     )

   )

which refers to the 8.1.7 database. You would now execute

exp username/password_at_NEWDB.MYDOMAIN.COM

to export the data from the 8.1.7 database with the export utility from your 8.1.6 installation.

Regards,

Knut Received on Mon May 06 2002 - 16:33:06 CEST