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))
Migrating data from Oracle 10g R2 64-bit to Oracle 10g R2 32-bit [message #276732] Fri, 26 October 2007 02:43 Go to next message
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?
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.
What is the way you used?

Regards
Michel
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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.
Re: Migrating data from Oracle 10g R2 64-bit to Oracle 10g R2 32-bit [message #280503 is a reply to message #280225] Tue, 13 November 2007 22:09 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

monto wrote on Tue, 13 November 2007 07:40

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


I see all the options he specified can be done.
Re: Migrating data from Oracle 10g R2 64-bit to Oracle 10g R2 32-bit [message #280686 is a reply to message #276732] Wed, 14 November 2007 09:10 Go to previous message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
yep,thanks for Metalink Note: 62290.1
Previous Topic: finding database size & finding how many databases are running
Next Topic: startup database
Goto Forum:
  


Current Time: Fri Dec 02 14:33:28 CST 2016

Total time taken to generate the page: 0.27021 seconds