> Luca wrote:
>
> I'm trying to import a dump made from an Oracle 8.1.6 into my server
> Oracle 8.0.5
> but when I start this message appear:
>
> ------------------------------------
> Connected to: Oracle8 Enterprise Edition Release 8.0.5.0.0 -
> Production
> PL/SQL Release 8.0.5.0.0 - Production
>
> Export file created by EXPORT:V08.01.06 via conventional path
> import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR
> character set
> IMP-00003: ORACLE error 2248 encountered
> ORA-02248: invalid option for ALTER SESSION
> IMP-00000: Import terminated unsuccessfully
> ------------------------------------
>
> This is the command I start from a pc with Oracle 8.1.6:
>
> imp bnl/*****@global fromuser=bnl touser=bnl file=e:\temp\bnl.dmp
> log=e:\temp\bnl.log
>
> Could someone help me?
>
> Many thanks to ng!
> Luca
Sigh... versions? imp V8.1.6 is *not* compatible
with 8.0.5! An 8.1.6 export file is incompatible with
imp V8.0.5.
Make an export with the lowest version tool (same as rdbms).
When lucky, that will work (not sure about compatibility of
imp/exp views between 8.0.5 and 8.1.6)
--
Gtrz,
Frank van Bortel
Received on Thu Jan 03 2002 - 09:58:10 CST
