Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Migrating Oracle 8161 32 bits to Oracle 8172 64bits on HP-UX 11.0

FRIAUD
Occasional Contributor

Migrating Oracle 8161 32 bits to Oracle 8172 64bits on HP-UX 11.0

Hello,
Do you have any experience of problem using export/import method, that is full export of Oracle 8.1.6.1 Database, then full import in a Oracle 8.1.7.2 database ?
Any experience.


4 REPLIES
Christopher Caldwell
Honored Contributor

Re: Migrating Oracle 8161 32 bits to Oracle 8172 64bits on HP-UX 11.0

No worries. Works like a champ.
A. Clay Stephenson
Acclaimed Contributor

Re: Migrating Oracle 8161 32 bits to Oracle 8172 64bits on HP-UX 11.0

No problems. Simply do a full export/import and you will be fine.

If it ain't broke, I can fix that.
Alexander M. Ermes
Honored Contributor

Re: Migrating Oracle 8161 32 bits to Oracle 8172 64bits on HP-UX 11.0

Hi there.
Just one little thing.
If you work with NLS language different from US, you should set
the NLS_LANGUAGE=American_America.....

Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Carlos Sotelo Ibarra_1
Frequent Advisor

Re: Migrating Oracle 8161 32 bits to Oracle 8172 64bits on HP-UX 11.0

Alexander,
You noted that NLS language has to be set to American_America. We intend to migrate an American_America db to a system that has the install option set for Spanish and a different character set... NLS is not installed yet as we intendo to do it once the migration process is complete. That could mess things up, wouldn't it? What would you suggest?
A pint of Guiness is worth an ounce of prevention