Re: Export 8.05 ----> 7.3.4

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).

"George Leontiadis" <gleon_at_dblab.ece.ntua.gr> wrote in message news:ehigr1$1nkb$1_at_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 Tue Oct 24 2006 - 14:02:55 CDT