Re: ORA-22881: dangling REF during upgrade from 9i to 11g
From: Thorsten Jens <thojens_at_gmx.de>
Date: Thu, 13 Aug 2009 00:46:53 -0700 (PDT)
Message-ID: <24d9276c-d430-40f6-8bed-69790736464b_at_g10g2000yqh.googlegroups.com>
On Aug 13, 9:12 am, Thorsten Jens <thoj..._at_gmx.de> wrote:
> On Aug 12, 4:39 pm, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
>
> > This may be related to XDB with automatically installs on 11g. If you
> > do not use XDB in your 9.2 database but some or all of the XDB objects
> > are defined try dropping them before upgrading.
>
> Do you know if there's there a script for that? Or can I drop the
> entire XDB user?
Date: Thu, 13 Aug 2009 00:46:53 -0700 (PDT)
Message-ID: <24d9276c-d430-40f6-8bed-69790736464b_at_g10g2000yqh.googlegroups.com>
On Aug 13, 9:12 am, Thorsten Jens <thoj..._at_gmx.de> wrote:
> On Aug 12, 4:39 pm, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
>
> > This may be related to XDB with automatically installs on 11g. If you
> > do not use XDB in your 9.2 database but some or all of the XDB objects
> > are defined try dropping them before upgrading.
>
> Do you know if there's there a script for that? Or can I drop the
> entire XDB user?
Found it, it's ?/rdbms/admin/catnoqm.sql. I'll run the script, try the upgrade again (it's a test environment, anyway) and report back.
Thorsten Received on Thu Aug 13 2009 - 02:46:53 CDT