Re: moving from 8.1.6 to 7.3.4

In sqlplus or svrmgrl,
connected as any user with sysdba privilege issue
@%ORACLE_HOME%\rdbms\admin\catexp7.sql

Then switch to your Oracle 7 dba client and run exp73 (in a DOS box) against the Oracle 8i database.
Of course sqlnet2.3 on your Oracle 7 client should have been setup to reach the Oracle 8i database.

This should be all.

Hth,

Sybrand Bakker, Oracle DBA

"Choung Chao" <cchao_at_pmc.ca> wrote in message news:qIG76.119642$Z2.1401530_at_nnrp1.uunet.ca...
> I'm not quite sure I understand the process exactly.
>
> am I supposed to run catexp7.sql in DOS or in sqlplus
> when do enter the export command.
> when am I supposed to do 7.3.4 exp against the Oracle 8i database.
>
> the process is confusing me.
>
> <sybrandb_at_my-deja.com> wrote in message
 news:93n46j$c9h$1_at_nnrp1.deja.com...
> > In article <q6E76.119608$Z2.1399840_at_nnrp1.uunet.ca>,
> > "Choung Chao" <cchao_at_pmc.ca> wrote:
> > > Hi,
> > >
> > > Is it possible to move from Oracle 8.1.6 to Oracle 7.3.4? Someone
 told me
> > > at one point that is was possible. If it is, how would I go about
 doing it?
> > > This is on Windows NT service pack 4
> > >
> > > thanks
> > >
> > > Choung
> > >
> > >
> >
> > Why on earth would you like to move *to* desupported software.
> > If you still want to do that, you need to run catexp7.sql in
> > $ORACLE_HOME/rdbms/admin against the 8i database. Secondly you need to
> > run 7.3.4 exp against the Oracle 8i database.
> > Import the data in your 7.3.4 database, loose all 8i features and back
> > your are in history.
> >
> > Hth,
> >
> >
> > --
> > Sybrand Bakker, Oracle DBA
> >
> > All standard disclaimers apply
> > ------------------------------------------------------------------------
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>
Received on Fri Jan 12 2001 - 13:24:04 CST