Re: backup/restore of a table with multiple xmltype columns failing
From: <wallyraju_at_gmail.com>
Date: Mon, 5 Jan 2009 08:26:31 -0800 (PST)
Message-ID: <8d9569d9-5912-437c-b435-660e93f07298_at_n33g2000pri.googlegroups.com>
On Jan 5, 10:53 am, ddf <orat..._at_msn.com> wrote:
> On Jan 5, 9:37 am, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
>
>
>
> > On Jan 5, 9:57 am, wallyr..._at_gmail.com wrote:
>
> > > Operating System: Sun Solaris 10
> > > Database Version: 10.2.0.1.0 64 bit
> > > Rac: 2 nodes
> > > export/import: using the expdp and impdp command
>
> > > We have a table which has an xmltype column amongst other columns. We
> > > had a problem importing data into the table from an export of the same
> > > table. We found out from searching online that we had to grant the
> > > schema owner 'ALTER SESSION' privilege to make it work and its been
> > > working fine since.
>
> > > We now have 2 xmltype columns in the same table and the import started
> > > bombing again. We have created a ticket with Oracle Support and they
> > > they were able to recreate it and are working on a solution.
>
> > > I was wondering if anyone has come across the same scenario before and
> > > if so how did you get around it.
>
> > > Thanks in advance.
>
> > Any specific reason why you are running 10.2 base install instead of
> > running on the 10.2.0.4 patchset?
>
> > The old shot in the dark guess is that are running into a bug that has
> > already been fixed ... but you have not installed available
> > maintenance.- Hide quoted text -
>
> > - Show quoted text -
>
> Your aim is apparently off, as the OP stated:
>
> "We now have 2 xmltype columns in the same table and the import
> started
> bombing again. We have created a ticket with Oracle Support and they
> they were able to recreate it and are working on a solution. "
>
> Which means, to me, it hasn't been fixed in any patchset currently
> available.
>
> David Fitzjarrell
Date: Mon, 5 Jan 2009 08:26:31 -0800 (PST)
Message-ID: <8d9569d9-5912-437c-b435-660e93f07298_at_n33g2000pri.googlegroups.com>
On Jan 5, 10:53 am, ddf <orat..._at_msn.com> wrote:
> On Jan 5, 9:37 am, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
>
>
>
> > On Jan 5, 9:57 am, wallyr..._at_gmail.com wrote:
>
> > > Operating System: Sun Solaris 10
> > > Database Version: 10.2.0.1.0 64 bit
> > > Rac: 2 nodes
> > > export/import: using the expdp and impdp command
>
> > > We have a table which has an xmltype column amongst other columns. We
> > > had a problem importing data into the table from an export of the same
> > > table. We found out from searching online that we had to grant the
> > > schema owner 'ALTER SESSION' privilege to make it work and its been
> > > working fine since.
>
> > > We now have 2 xmltype columns in the same table and the import started
> > > bombing again. We have created a ticket with Oracle Support and they
> > > they were able to recreate it and are working on a solution.
>
> > > I was wondering if anyone has come across the same scenario before and
> > > if so how did you get around it.
>
> > > Thanks in advance.
>
> > Any specific reason why you are running 10.2 base install instead of
> > running on the 10.2.0.4 patchset?
>
> > The old shot in the dark guess is that are running into a bug that has
> > already been fixed ... but you have not installed available
> > maintenance.- Hide quoted text -
>
> > - Show quoted text -
>
> Your aim is apparently off, as the OP stated:
>
> "We now have 2 xmltype columns in the same table and the import
> started
> bombing again. We have created a ticket with Oracle Support and they
> they were able to recreate it and are working on a solution. "
>
> Which means, to me, it hasn't been fixed in any patchset currently
> available.
>
> David Fitzjarrell
Sorry for not getting back earlier, but Oracle Support was able to reproduce the problem in 10.2.0.1, 10.2.0.4, and 11.1.0.7 Received on Mon Jan 05 2009 - 10:26:31 CST