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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
