Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Export 8.05 ----> 7.3.4

Re: Export 8.05 ----> 7.3.4

From: George Leontiadis <gleon_at_dblab.ece.ntua.gr>
Date: Mon, 23 Oct 2006 16:41:24 +0300
Message-ID: <ehigr1$1nkb$1@ulysses.noc.ntua.gr>

? "sybrandb" <sybrandb_at_gmail.com> ?????? ??? ?????? news:1161609181.792869.70660_at_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..._at_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..._at_gmail.com> ?????? ???
>> ??????news:1161602496.296264.264180_at_h48g2000cwc.googlegroups.com...
>>
>>
>>
>>
>>
>> > On Oct 23, 1:06 pm, "George Leontiadis" <g..._at_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 Received on Mon Oct 23 2006 - 08:41:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US