Re: Import 8.1.7 -> 8.1.6 gets an IMP-00069

"Jan Torres W." <jtorres_at_pironet.com> wrote in message news:3A8BCE16.AB4A0DC5_at_pironet.com...
> Thanks, Sybrand,
>
> now, what is best practice to get the 8.1.7 database tables (including
> constraints, views & SPs) from the production system at the customer's
 premises
> (behind a FW) into our development environment running 8.1.6?
>
> Regards,
> Jan Torres
>
> Sybrand Bakker wrote:
>
> > "Jan Torres W." <jtorres_at_pironet.com> wrote in message
> > news:3A8A90CA.5C1DC1BD_at_pironet.com...
> > > Hi,
> > > can anyone give me a hint as to where to look next?
> > > I've already done thru the Oracle Documentation to no avail...
> > > Thanks a lot,
> > >
> > > --
> > >
> > > Import: Release 8.1.6.0.0 - Production on Mo Feb 12 12:50:36 2001
> > >
> > > (c) Copyright 1999 Oracle Corporation. All rights reserved.
> > >
> > > Kennwort:
> > >
> > > Verbunden mit: Oracle8i Release 8.1.6.0.0 - Production
> > > JServer Release 8.1.6.0.0 - Production
> > > <
> > > Export-Datei wurde von EXPORT:V08.01.07 ³ber konventionellen Pfad
> > > erstellt
> > >
> > > Warnung: Die Objekte wurden von STD_USER exportiert, nicht von Ihnen.
> > >
> > > Importvorgang mit Zeichensatz WE8ISO8859P1 und Zeichensatz
 WE8ISO8859P1
> > > NCHAR du
> > > rchgef³hrt
> > > IMP-00069: Umwandlung in nationalen Umgebungszeichensatz-Handler
> > > fehlgeschlagen
> > > IMP-00000: Der Import-Vorgang endete mit Fehlern
> > >
> > >
> > > --
> > > Regards
> > >
> > > Jan Torres W. - Consultant - Solution Design
> > > Josef-Lammerting-Allee 14-18, 50933 Cologne - Germany
> > > Tel.: +49 (0)221 770 2730 - Fax: +49 (0)221 770 2205
> > > mailto:jtorres_at_pironet.com - http://www.pironet-ndh.com
> > >
> > > Visit PIRONET NDH at CeBIT 2001 in Hannover,
> > > hall 6, booth E05 from March 22nd to 28th.
> > >
> >
> > *Always* use the lower version exp against the higher version database.
> > You can import an 8.1.6 dump in 8.1.7 the other way around is *not*
 going to
> > work.
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > >
>
Option 1) run your 8.1.6 exp against the clients 8.1.7 database. Obviously they need to open port 1521 or 1526 and you need to use use_shared_sockets=true in sqlnet.ora
Option 2) travel to the client and install your 8.1.6 dba client software on a system behind the firewall, and run your export at the client's location.

Hth,

Sybrand Bakker, Oracle DBA Received on Fri Feb 16 2001 - 00:00:52 CET