Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!kanaga.switch.ch!switch.ch!news.grnet.gr!news.ntua.gr!not-for-mail
From: "George Leontiadis" <gleon@dblab.ece.ntua.gr>
Newsgroups: comp.databases.oracle.server
Subject: Re: Export 8.05 ----> 7.3.4
Date: Mon, 23 Oct 2006 16:41:24 +0300
Organization: National Technical University of Athens, Greece
Lines: 85
Message-ID: <ehigr1$1nkb$1@ulysses.noc.ntua.gr>
References: <ehi7p2$sn6$1@ulysses.noc.ntua.gr>   <1161602496.296264.264180@h48g2000cwc.googlegroups.com>   <ehi91v$10h5$1@ulysses.noc.ntua.gr> <1161609181.792869.70660@k70g2000cwa.googlegroups.com>
NNTP-Posting-Host: 212.205.107.114
X-Trace: ulysses.noc.ntua.gr 1161610913 56971 212.205.107.114 (23 Oct 2006 13:41:53 GMT)
X-Complaints-To: usenet@ulysses.noc.ntua.gr
NNTP-Posting-Date: Mon, 23 Oct 2006 13:41:53 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Original
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:277895


? "sybrandb" <sybrandb@gmail.com> ?????? ??? ?????? 
news:1161609181.792869.70660@k70g2000cwa.googlegroups.com...
> Too bad for the orginazation, and for your resume when they kick you
> out.
> 7.3.4 and 8.0.5 are both firmly rooted in the Jurassic Park.
> You don't drive a 20 year old car, do you?
>
> Assuming Windows, you must check the NLS_* variables in the registry,
> or Unix env vars if you are running Unix.
> v$nls_valid_values will tell you which values are possible.
> If you only installed Oracle in English, you don't have any
> international language library and can't use a 8-bit characterset.
>
> Please do not top post.
> Humans happen to read from top to bottom, not from bottom to top.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
>
>
>
>
> On Oct 23, 1:28 pm, "George Leontiadis" <g...@dblab.ece.ntua.gr>
> wrote:
>> Its not a museum lol ... on the contrary its a big public
>> organization........ :-P
>>
>> I already did the procedure you describe (as i mentioned in my post) but 
>> the
>> problem is still there .. i cannot find a solution :(
>>
>> Ps: (Actualy both servers are belonging to major public organizations
>>  haha )
>>
>> ? "sybrandb" <sybra...@gmail.com> ?????? ??? 
>> ??????news:1161602496.296264.264180@h48g2000cwc.googlegroups.com...
>>
>>
>>
>>
>>
>> > On Oct 23, 1:06 pm, "George Leontiadis" <g...@dblab.ece.ntua.gr>
>> > wrote:
>> >> I am trying to create an export file from my oracle server (8.0.5) to 
>> >> be
>> >> loaded on a 7.3.4 server
>>
>> >> I already run the catexp7.sql script but when i use the 7.3.4 exp tool 
>> >> on
>> >> my
>> >> server i get the following messages
>>
>> >> EXP-00008: ORACLE error 12705 encountered
>> >> ORA-12705: invalid or unknown NLS parameter value specified
>> >> EXP-00000: Export terminated unsuccessfully
>>
>> >> (The exp tool of 8.0.5 runs with out problems)
>>
>> >> Any help it would be greatly appreciated.
>>
>> >> Thanks
>>
>> > You need to, as usual, and as documented, use the 7.3.4 export using
>> > sqlnet against the 8.0.5 database.
>> > The other way around won't work, ever. Running catexp7.sql in the 8.0.5
>> > database is required, as you already noted.
>> > Just out of curiosity: in which museum is this configuration located?
>>
>> > --
>> > Sybrand Bakker
>> > Senior Oracle DBA- Hide quoted text -- Show quoted text -
>

When i am in a firm i work with the tools that the firm has...

I must adapt to the company and not the company to me

Its an AIX/UNIX installation and all the nls variables are set

Also humans happen to be polite


