>>>Install 8174 (64 bit) software >>>Convert the db from 32 bit to 64 (8174) >>>migrate the db from 8174 (64 bit) to 9204 (64 bit). Srinivas, I do not think you need to perform the 64 bit conversion step at all. Oracl= e does the word size conversion during the upgrade implicitly.=20 I have done such upgrade using the DBUA and using scripts without any issue= s... B. -----Original Message----- From: DENNIS WILLIAMS [mailto:DWILLIAMS@xxxxxxxxxxxxx] Sent: Thursday, April 01, 2004 3:46 PM To: 'oracle-l@xxxxxxxxxxxxx' Subject: RE: 8174 32 bit to 9204 64 big Srinivas My theory as a DBA is to perform tasks in a manner that is least likely to cause bad consequences. Is there any way export/import would work for you? I have a much warmer feeling about using that to relocate my important data. Just create a new 9i database, check it out, make sure it is ready to go, practice the export/import, then perform the cutover. Much less to go wrong. Dennis Williams DBA Lifetouch, Inc. dwilliams@xxxxxxxxxxxxx=20 ___________________________________________________________________________= __________________________________ This electronic transmission and any attached files are intended solely for= the person or entity to which they are addressed and may contain informati= on that is privileged, confidential or otherwise protected from disclosure.= Any review, retransmission, dissemination or other use, including taking a= ny action concerning this information by anyone other than the named recipi= ent, is strictly prohibited. If you are not the intended recipient or have = received this communication in error, please immediately notify the sender = and destroy this communication. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------