Migration question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Migration question

  1. #1
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234

    Question

    All,

    Can you upgrade from 817 to 9i with the u0801070.sql in the $ORACLE_HOME/rdbms/admin directory??

    I used the odma which worked but I'm just curious.

    Tycho

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    ODMA executes that (or a similar) script as part of the upgrade.

    But there are other steps that ODMA performs as well.

    Just by running the script, you will not successfully upgrade.

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234

    Thumbs up

    Hi dknight,

    Thanx

    I know some dirty tricks already when upgrading from 8.0.5 to 8.1.7. (setting _system_trig_enbled = false).

    I 'll try out the U0801070.sql tonight.
    Kind regards,

    Tycho

  4. #4
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    If you run the ODMA and save the scripts rather than run them immediately you'll see exactly what it does to upgrade the instance.
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

Posting Permissions

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


Click Here to Expand Forum to Full Width