Re: export & import data base without exp.exe & imp.exe

On Mon, 4 Aug 2003 11:10:07 +0100, Lamjed <balamjed_at_chez.com> wrote:

> Hi,
>
> I have database ver 8.0.5 in sun micro system, and in my computer I have
> local database with oracle 8.1.6 in windows 2000, sow imp.exe and exp.exe
> ver 8.1.6 (with toad utility) don't work with database 8.0.5

Of course exp 8.1.6 won't work with an 8.0.5 database... but that's what the exp 8.0.5 is there for. It will export the 8.0 database into an 8.0- compatible dump file. And import is backwardly-compatible, so your 8.1.6- version of imp will be able to read the 8.0 dumpfile without a problem.

Just navigate directly to the ORACLE_HOME/bin directory for the 8.0 database, and launch export from there. Then do likewise with the 8.1.6 ORACLE_HOME/bin to make sure you run the 8.1.6 version of the import utility.

~QM

>
> "Lamjed" <balamjed_at_chez.com> a écrit dans le message news:
> bgamtg$mij2m$1_at_ID-127366.news.uni-berlin.de...
>> Hi,
>>
>> can any one help me to export & import data base without exp.exe &
>> imp.exe
>>
>> thanks
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003
>
>
>
>

-- 
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/