Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: upgrading from 8174 32 bit to 9.2 64 bit

    I'm in the process of trialling a migration path from oracle 32 bit to 9.2.0 64 bit.
    I have built the 9i database with locally managed tbspaces and temporary files for the temporary tablespaces.
    I've also changed from using rollback segs to an automatic undo.
    I am planning to import the 8.1.7 db in and recompile everything.
    Is there anything else I need to consider?
    Is it OK to move from 32 bit to 64 bit in this way?

  2. #2
    Join Date
    Jan 2003
    Vienna, Austria

    Re: upgrading from 8174 32 bit to 9.2 64 bit

    I often use exp/imp to migrate from 8i to 9iR2.
    It's fine if you use the new features (UNDO, temp-TS, etc)
    If you are using only basic SQL features there will be no big difference.
    But if you are using a lot of PL/SQL procedures or java you have to check the functionality carefully.
    As an example, UTL_FILE_DIR has changed in 9iR2.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts