| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re: 8174 32 bit to 9204 64 big
The whole issue with 32-bit and 64-bit wordsize within the database involves compiled objects only -- PL/SQL and Java. When changing the wordsize, you have to invalidate and revalidate all such compiled objects within the database. Documentation on MetaLink describes this quite well...
Bouncing back and forth between 32-bit and 64-bit versions of software without export/import is just not a big issue, unless you have a ton of compiled objects. For OraApps R11i, with over 200,000 compiled objects, performing invalidation and recompilation in serial can take 6-8 hours. In that case, look at the doc for the UTL_RECOMP package to recompile in parallel, which helps bring the time down quite a bit...
Will datafiles will be converted? My point was export and import with change of platform. Besides in my senrio it was moving from 64 bit database to 32 bit database as well.
Return-Path: <oracle-l-bounce_at_freelists.org> Received: from sagesun01.sagelogix.com by ocs.sagelogix.com
with ESMTP id 1009801081263929; Tue, 06 Apr 2004 09:05:29 -0600 Received: by mail.sagelogix.com (Postfix, from userid 70101)
id 01261317AA; Tue, 6 Apr 2004 09:06:35 -0600 (MDT) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180])
by mail.sagelogix.com (Postfix) with ESMTP id 559373179E for <tim_at_sagelogix.com>; Tue, 6 Apr 2004 09:06:22 -0600 (MDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 11E36636236; Tue, 6 Apr 2004 10:02:11 -0500 (EST)Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22152-47; Tue, 6 Apr 2004 10:02:10 -0500 (EST) Received: from turing (localhost [127.0.0.1])
by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 92B1463621A; Tue, 6 Apr 2004 10:01:57 -0500 (EST)Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 06 Apr 2004 10:00:49 -0500 (EST) X-Original-To: oracle-l_at_freelists.org
by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5506E636182 for <oracle-l_at_freelists.org>; Tue, 6 Apr 2004 10:00:48 -0500 (EST)Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21406-86 for <oracle-l_at_freelists.org>; Tue, 6 Apr 2004 10:00:48 -0500 (EST)
by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0D86F63617D for <oracle-l_at_freelists.org>; Tue, 6 Apr 2004 10:00:47 -0500 (EST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 6 Apr 2004 08:09:59 -0700 Received: from 165.89.84.86 by by99fd.bay99.hotmail.msn.com with HTTP; Tue, 06 Apr 2004 15:09:59 GMT X-Originating-IP: [165.89.84.86]
X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on mail.sagelogix.com X-Spam-Level: * X-Spam-Status: No, hits=1.9 required=3.0 tests=FROM_ENDS_IN_NUMS, MAILTO_TO_SPAM_ADDR autolearn=no version=2.63
You may be right. Tim is saying 32 to 64 bit conversion. What about 64 to 32 bit conversion alongwith change of platform? Is there any viable option other than export and import regardless difficulties of size and bug handling?
Will datafiles will be converted? My point was export and import with change of platform. Besides in my senrio it was moving from 64 bit database to 32 bit database as well.
With my long experience with Oracle since ver 4 and 5, I never trusted export as the best solution although they have improved a lot and famous message' abnormal end of file' while import has gone. away now.
Regards
Rafiq
From: "M.Godlewski" <mcgodlewski_at_yahoo.com>
Reply-To: oracle-l_at_freelists.org
To: oracle-l_at_freelists.org
Subject: Re: 8174 32 bit to 9204 64 big
Date: Tue, 6 Apr 2004 07:12:35 -0700 (PDT)
I agree with Tim. Newer features with export import may not work!
For example export/import of XML DB xml documents/tables with registered
schemas for version 9.2.0.4 at this time doesn't work correctly. According
to Oracle support, I have to re-register the schema and then try an import
of the tables. I'm upgrading to 9.2.0.5 to see if it's fixed. If not
development will do a bug fix on the later patch version 9.2.0.5.
Tim Gorman <tim_at_sagelogix.com> wrote:If change of platforms is not part of
the task, then I strongly disagree.
Export/Import is riskier and slower.
Upgrading the software and performing the 32-64 bit update according to the plentiful documentation on Metalink is faster and safer than exporting and importing. It's really the only viable option for a database of any size.
on 4/2/04 10:37 AM, M Rafiq at rafiq9857_at_hotmail.com wrote:
> I think there should not be any disagreement on this. As suggested by
Dennis
> , create a new database under 9i and import 8i database export there.
>
> I did the same thing last month as I have to change the
> 1)platform Sun to Linux
> 2)from 64 bit to 32 bit machine and oracle as well.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- --------------------------------- Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway - Enter today ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- _________________________________________________________________ Watch LIVE baseball games on your computer with MLB.TV, included with MSN Premium! http://join.msn.com/?page=features/mlb&pgmarket=en-us/go/onm00200439ave/direct/01/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Apr 06 2004 - 11:23:35 CDT
 |
 |