| Database conversion needed if migrating from 32-bit to 64-bit Oracle [message #60199] |
Fri, 23 January 2004 00:37  |
Jaideep
Messages: 1
Registered: January 2004
|
Junior Member |
|
|
Hi,
Currently 32 bit Oracle database is running,Now if i install 64-bit Oracle of the same version , can i use the existing database with out migration.
Current Solaris7 - oracle 8.1.6.3 32- bit
Proposed Solaris8 - Oracle 8.1.6.3 64-bit
Database need to be upgraded in this case or existing can be used
Thanks
|
|
|
|
| Re: Database conversion needed if migrating from 32-bit to 64-bit Oracle [message #60206 is a reply to message #60199] |
Fri, 23 January 2004 03:32  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Yes, it is possible. See Metalink Note:164997.1 - "How to Upgrade a Database from 32 Bit Oracle to 64 Bit Oracle"
To view this note, click "Advanced" next to the search field at top of the MetaLink screen. In Advanced Search Site, ensure DocID and Knowledge Base are selected, and enter entire article number (164997.1) into search field and click Search.
Best regards.
Frank
|
|
|
|
|
|
| Re: Database conversion needed if migrating from 32-bit to 64-bit Oracle [message #60247 is a reply to message #60199] |
Tue, 27 January 2004 05:52 |
Sanjay
Messages: 236
Registered: July 2000
|
Senior Member |
|
|
Yes this is possible. You will need to make all the objects INVALID and recompile them again. There is a script for that (?/rdbms/admin/utlirp.sql)
This is documented in the 32-bit to 64-bit conversion doc. This is needed ONLY because you are changing from 32 to 64 bit.
We went from 81630 32-bit to 81740 64-bit, no probs.
--
Sanjay
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
