What are the main challenges when working with both Oracle 64 bit and 32 bit versions?

An Oracle user asks about potential problems when importing and working with both 32-bit and 64-bit versions.

I have an Oracle 10g x86-64 on a SUSE Enterprise Edition 10 64 bit edition. I also have an Oracle 10g x86 on SUSE 9 32 bit. Can I import dumps from a 64 bit to a 32 bit version? What are the main challenges when working with both Oracle 64 bit and 32 bit versions?
The import utilities do not really care about whether it is a 32-bit or 64-bit version. So you should be able to import into 32-bit Oracle from a 64-bit dump file without problems.

For the most part, I really never worry about the word size (32 or 64 bit) when dealing with Oracle. If you have...

a 32-bit operating system, then you are constrained to a 32-bit Oracle version. If you are running a 64-bit OS, then you can run either Oracle word version, but in most cases, one would choose the 64-bit version. The 64-bit version will let you allocate a larger SGA than the 32-bit version, but other than that, most Oracle DBAs never give this much thought. There are probably a few minor points to consider for a very specific situation, but I haven't run into them.

This was last published in March 2008

Dig Deeper on Oracle database administration



Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: