Re: Export 8.05 ----> 7.3.4

"George Leontiadis" <gleon_at_dblab.ece.ntua.gr> wrote
>
> Ο "kvmb" <kvmb_at_nospam.com> έγραψε στο μήνυμα news:zrt%g.146608$pI.2513973_at_phobos.telenet-ops.be...
>> The Oracle dmp contains characterset information.
>>
>> As you said NLS_LANG is set - but it is most probably set to a characterset
>> that is not supported in Oracle 7.
>> So, change the characterset part of NLS_LANG, on the client you are running
>> exp on, to something Oracle 7
>> understands (see the v$nls_valid_values part in sybrand's reply).
>
> Thanks for your reply.. but both dbs (source 8.0.5) and destination (7.3.4) use the same nls_lang
> paramaters that seems to be supported by the v$nls_valid_values (i will try different value
> though)
>
> but unfortunatelly the export tool which i took from the 7.3.4. version and run against 8.0.5
> produces the errors mentioned :
> EXP-00008: ORACLE error 12705 encountered
> ORA-12705: invalid or unknown NLS parameter value specified
>
> I cant find a solution yet.. i am guessing i will do a csv export / sqlldr import

Did you really use the 7.3.4 export through SQLNET against the 8.0.5 database. So from the 7.3.4 home and settings use exp to connect to

   exp username/passwd @805databasealias ?

That can really make the difference; as already noted.

Cheers, Roelof Received on Wed Oct 25 2006 - 10:04:43 CDT