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

Thread: Migration question

  1. 03-01-2002, 07:31 PM #1
    tycho
    tycho is offline Member
    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
    Reply With Quote Reply With Quote
  2. 03-02-2002, 07:13 AM #2
    dknight
    dknight is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  3. 03-04-2002, 10:31 AM #3
    tycho
    tycho is offline Member
    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
    Reply With Quote Reply With Quote
  4. 03-04-2002, 10:50 AM #4
    TimHall
    TimHall is offline Senior Advisor
    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: oracle-base.com
    My blog: oracle-base.com/blog
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width