Re: Export 8.05 ----> 7.3.4

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 -