drop table error in migration 9i to 10g AIX

From: Rodd Holman <Rodd.Holman_at_gmail.com>
Date: Tue, 06 Nov 2007 16:19:17 -0600
Message-ID: <4730E865.9070400@gmail.com>

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

Received on Tue Nov 06 2007 - 16:19:17 CST