OraFAQ Forum: Server Administration » Migrating data from Oracle 10g R2 64-bit to Oracle 10g R2 32-bit

Home » RDBMS Server » Server Administration » Migrating data from Oracle 10g R2 64-bit to Oracle 10g R2 32-bit (Oracle 10g R2 64-bit, Oracle 10g R2 32-bit, Windows 2003 Enterprise Ed.(64-bit), Windows 2003 Enterprise Ed.(32-bit))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Migrating data from Oracle 10g R2 64-bit to Oracle 10g R2 32-bit [message #276732]

Fri, 26 October 2007 02:43

sawcna
Messages: 4
Registered: July 2007

Junior Member

I want to migrate production data to development environment. Prodcution Environment is using 64-bit Oracle 10g R2 and Development Environment is using 32-bit Oracle 10g R2. OS is Windows 2003 64-bit and Windows 2003 32-bit respectively. Current Production db size is approx. 1 TB. What is the best approach(e.g data pump, Transportable tablespace) to migrate data from production environment to development environment? Can I just copy data files from production environment to development enviroment, recreate control file and bring up the db at development environment?

Report message to a moderator

Re: Migrating data from Oracle 10g R2 64-bit to Oracle 10g R2 32-bit [message #276753 is a reply to message #276732]

Fri, 26 October 2007 04:41

lazycat
Messages: 57
Registered: November 2005

Member

you can try it on window
but in other os you can't do it like it
test it

Report message to a moderator

Re: Migrating data from Oracle 10g R2 64-bit to Oracle 10g R2 32-bit [message #279935 is a reply to message #276753]

Mon, 12 November 2007 00:12

sawcna
Messages: 4
Registered: July 2007

Junior Member

Just want to update the status. To be summarized: copying datafile from 64-bit and 32-bit environment didn't work.

Report message to a moderator

Re: Migrating data from Oracle 10g R2 64-bit to Oracle 10g R2 32-bit [message #279938 is a reply to message #279935]

Mon, 12 November 2007 00:27

Michel Cadot
Messages: 68684
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Thanks for the feedback.
What is the way you used?

Regards
Michel

Report message to a moderator

Re: Migrating data from Oracle 10g R2 64-bit to Oracle 10g R2 32-bit [message #280225 is a reply to message #276732]

Mon, 12 November 2007 19:40

monto
Messages: 60
Registered: November 2007
Location: DALLAS

Member

Only option i see is using datapump which is faster than normal exp/imp use parallel to speed up.

Report message to a moderator

Re: Migrating data from Oracle 10g R2 64-bit to Oracle 10g R2 32-bit [message #280227 is a reply to message #276732]

Mon, 12 November 2007 19:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Just want to update the status. To be summarized: copying datafile from 64-bit and 32-bit environment didn't work.
Metalink Note: 62290.1
Changing between 32-bit and 64-bit Word Sizes

I've done this successfully on more than 1 occasion.

Report message to a moderator