Damien,

Yes, what you want to do will work fine. After the database is restored
to the 32bit server you will need to execute utlirp.sql from
$ORACLE_HOME/rdbms/admin to recompile all of the PL*SQL.

Besides that, it should be an easy exercise.

-Bennett

Pinault, Damien wrote:

>I am wondering if this is feasible :
>
>Our production is on Oracle 10GR2 64bits ( SLES 9 SP3 )
>Our development is on Oracle 10GR2 32bits ( SLES 9 SP3 )
>
>Can you backup your production DB with RMAN and recover it on the dev
>server ??
>I know you can twick (remap) your tablespaces location when you restore,
>but I have no idea about the global conversion. ( 64 -> 32 )
>
>Any documentaion or ideas will be really beneficial.
>
>Tks in advance,
>
>D>
>
>--------------------------------------------
>VFA, Inc.        http://www.vfa.com
>--------------------------------------------
>
>
>


--
-Bennett Leve
RAC BDE Senior Manager


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting