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@xxxxxxxxxxxxx> 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@xxxxxxxxxxx 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@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 ----------------------------------------------------------------- --------------------------------- 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@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 -----------------------------------------------------------------