FAQ
Hi all,
Having an issue during the upgrade of a 9.2.0.5 to 10.2.0.3.

Server IBM p550
16 G Ram
cio storage (filesystem_options=setall)

Step 31 of oracle's upgrade doc says to drop XDB.MIGR9202STATUS.

When we attempt that we get the following:

SQL> drop table XDB.MIGR9202STATUS;
drop table XDB.MIGR9202STATUS

*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

Elapsed: 00:00:00.03
SQL>

Have any of you come across this? How did you get around it?

Thanks

Rodd Holman

Search Discussions

  • Asif Momen at Nov 7, 2007 at 1:57 pm
    Hi Rodd,

    Last week when we were upgrading our 9.2.0.5 to 10.2.0.3 we got stuck at this point. Google and Metalink were also helpless.

    Oracle support has updated the document 316889.1 which includes step 31. We have a copy of the same document which is nearly a year old and Step 31 is not there.

    We ignored that step and continued with the next step during our upgrade and all went fine in our case.

    Hope the same holds good with you as well.

    All the best !!!!

    Regards

    Asif Momen
    http://momendba.blogspot.com

    Rodd Holman wrote: Hi all,
    Having an issue during the upgrade of a 9.2.0.5 to 10.2.0.3.

    Server IBM p550
    16 G Ram
    cio storage (filesystem_options=setall)

    Step 31 of oracle's upgrade doc says to drop XDB.MIGR9202STATUS.

    When we attempt that we get the following:

    SQL> drop table XDB.MIGR9202STATUS;
    drop table XDB.MIGR9202STATUS

    *

    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-00942: table or view does not exist

    Elapsed: 00:00:00.03
    SQL>

    Have any of you come across this? How did you get around it?

    Thanks

    Rodd Holman

    --
    http://www.freelists.org/webpage/oracle-l

    Do You Yahoo!?
    Tired of spam? Yahoo! Mail has the best spam protection around
    http://mail.yahoo.com
    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedNov 6, '07 at 10:19p
activeNov 7, '07 at 1:57p
posts2
users2
websiteoracle.com

2 users in discussion

Rodd Holman: 1 post Asif Momen: 1 post

People

Translate

site design / logo © 2022 Grokbase