Re: Backup from 64 bit and restore to 32 bit

rinaldof_at_gmail.com wrote:
> Hi.
>
> We have an oracle 10g database running on a Windows 2003 64 bit server
> and another oracle 10g database running on a Windows 2003 32 bit
> server. The databases are identical, except from the fact that the 32
> bit version is used as a test server, so the data is different.
>
> We need to make the test server really identical to the production
> server. How can we export the data/structures from the 64 bit database
> to the 32 bit database? I have read some articles about backup policies
> and it seems that it is necessary to downgrade the 64 bit database to
> 32 bit. Is it the only way?
>
> Thanks,
> Rinaldo Ferreira Junior

No matter what you do, your xplans plans will differ based on this setup. Make no assumptions as to the linear performance on the 64 bit system. Even if you were using the same OS on each system, this would still be the case. The simple things will appear or be the same on small scale, but larger, more complex queries will start to vary. This is just something to watch for, so do be surprised if 32 bit out performs 64 sometimes.... Received on Mon Jan 08 2007 - 00:00:37 CST