import to another instance
From: Alexander Welti <alex_at_welti.at>
Date: Mon, 2 Apr 2001 19:01:18 +0200
Message-ID: <9aab1g$tvd$1_at_rohrpostix.uta4you.at>
Date: Mon, 2 Apr 2001 19:01:18 +0200
Message-ID: <9aab1g$tvd$1_at_rohrpostix.uta4you.at>
Hi!
I have an export file from an oracle database and I want to import it to my oracle database. The following problem I have:
[Quoted] my db was installed with charset we8iso8859p1, so I thought it was possible to create a second instance with the correct charset of the export file to import it to this second instance.
[Quoted] my question: is this possible? And how do I tell imp to use the second instance and not the first one?
[Quoted] I tried to shut down my first instance and leave the second open, imp said oracle is not available.
[Quoted] Must the SID be the same as in the original database?
Thanks, Alex Received on Mon Apr 02 2001 - 19:01:18 CEST