8174 32 bit to 9204 64 big 2004-04-06 - By tim@(protected)
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...
-- ----- original message -- ---- ---- ---- ----
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.
-- Attached file included as plaintext by Ecartis --
-- File: Re: 8174 32 bit to 9204 64 big
Return-Path: <oracle-l-bounce@(protected) >
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@(protected) >; 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@(protected)
Delivered-To: oracle-l@(protected)
Received: from localhost (localhost [127.0.0.1])
by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5506E636182
for <oracle-l@(protected) >; 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@(protected) >;
Tue, 6 Apr 2004 10:00:48 -0500 (EST)
Received: from hotmail.com (bay99-f45.bay99.hotmail.com [65.54.175.45])
by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0D86F63617D
for <oracle-l@(protected) >; 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-Originating-Email: [rafiq9857@(protected)]
X-Sender: rafiq9857@(protected)
From: "M Rafiq " <rafiq9857@(protected) >
To: oracle-l@(protected)
Subject: Re: 8174 32 bit to 9204 64 big
Date: Tue, 06 Apr 2004 11:09:59 -0400
Mime-Version: 1.0
Content-type: text/plain
Message-ID: <BAY99-F457KBsMajCZu00028228@(protected) >
X-OriginalArrivalTime: 06 Apr 2004 15:09:59.0742 (UTC) FILETIME=[3A9575E0:01C41BE9]
X-Virus-Scanned: by amavisd-new at freelists.org
Content-Transfer-Encoding: 8bit
X-archive-position: 2610
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@(protected)
Errors-To: oracle-l-bounce@(protected)
X-original-sender: rafiq9857@(protected)
Precedence: normal
Reply-To: oracle-l@(protected)
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@(protected) >
Reply-To: oracle-l@(protected)
To: oracle-l@(protected)
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@(protected) > 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@(protected) 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.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- -----
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@(protected)
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žatures/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@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
