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

Any solution of which I am aware, between 32 and 64, will result likely result in a different clustering factor. Management needs to step up to the plate ... preferably moving from Windows to Linux at the same time.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org