 | | | 8174 32 bit to 9204 64 big | 8174 32 bit to 9204 64 big 2004-04-06 - By M Rafiq
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
|