 | | | AW: RE: [suse-oracle] Downgrade from ORACLE 10g R2 to R1 | AW: RE: [suse-oracle] Downgrade from ORACLE 10g R2 to R1 2006-09-14 - By CLEMENS.BLEILE@(protected)
Back
Hi,
see Metalink Note 132904.1 concerning exp/imp between different DB-versions.
Exporting from 10grR2 and importing in 10gR1 it is recommended to use Data Pump
. If you insist that you want to use exp/imp then follow these steps:
1.) run catexp.sql from 10gR1 against 10gR2
2.) exp with the 10gR1 exp executable
3.) imp into 10gR1 with the usual 10gR1 imp executable
4.) If you continue using your 10gR2 DB then run catexp.sql of 10gR2 against
your 10gR2 DB
However, coming back to your original question:
"due to some problem, I need to downgrade it to 10gR1"
What are your problems? Maybe it's enough to run your 10gR2 Db with
compatible = 10.1.0.2.0
optimizer_features_enable = 10.1.0.4
But you probably have to downgrade to reset your database to 10.1.
compatibility. Check your Database Upgrade Guide on how to perform the
downgrade.
Ciao
Clemens
--- Originalnachricht ---
> Try export the 10gR2 database with the 10gR1 exp command and
> the try to
> import it with the imp of the 10gR1.
>
> Manuel Machado
> Projecto de Sistemas de Informa??o
> FEUP
> Rua do Dr. Roberto Frias s/n
> 4200-465 Porto
>
>
> -- --Original Message-- --
> From: Ronny Egner [mailto:Ronny.Egner@(protected)]
> Sent: quarta-feira, 13 de Setembro de 2006 11:04
> To: Seah Hong Yee
> Cc: 'SuSE MailingList'
> Subject: Re: [suse-oracle] Downgrade from ORACLE 10g R2 to R1
>
> Seah Hong Yee schrieb:
> > Hello,
> >
> >
> > I have a system that has Oracle 10g R2 however, due to some problem, I
> > need to downgrade it to 10gR1.
> >
> > Currently, I tried using the data pump export utility. However, I kept
> > getting a bunch or error from when I try to import in R1. Is there a
> > way to fix this ?
>
> I still prefer exp/imp because data pump does not work correctly
> for my
> schemas.
>
> But you will have a lot of problems importing data from a newer
> database
> (10g R2) into an older version (10g R1).
>
> You could try exp/imp and if it does not work you could use
> database links.
>
> --
>
>
>
> Mit freundlichen Gr??en
>
> Ronny Egner
> Diplom-Ingenieur (BA)
>
> SIV.AG
> Konrad-Zuse-Stra?e 1
> 18184 Roggentin
>
> Telefon: +49 (0)3 81 / 25 24 422
> Telefax: +49 (0)3 81 / 25 24 399
>
> mailto:ronny.egner@(protected)
> http://www.siv.de
>
> **********************************************************************
> This email and any files transmitted with it are confidential
> and intended
> solely for the use of the individual or entity to whom they
> are addressed.
> The views expressed in this e-mail are those of the individual
> author and
> not necessarily those of SIV.AG.
>
> This footnote also confirms that this email message has been
> swept by serval
> anti-virus tools for the presence of computer viruses.
> **********************************************************************
>
>
>
>
> --
> To unsubscribe, email: suse-oracle-unsubscribe@(protected) For
> additional
> commands, email: suse-oracle-help@(protected) Please see
> http://www.suse.com/oracle/ before posting
>
>
>
> --
> To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> For additional commands, email: suse-oracle-help@(protected)
> Please see http://www.suse.com/oracle/ before posting
>
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
|