Re: backup/restore of a table with multiple xmltype columns failing
From: ddf <oratune_at_msn.com>
Date: Mon, 5 Jan 2009 08:43:13 -0800 (PST)
Message-ID: <bc442b77-616c-47cc-8c81-cca07e2ec8ee_at_o4g2000pra.googlegroups.com>
On Jan 5, 10:26 am, wallyr..._at_gmail.com wrote:
> 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- Hide quoted text -
>
> - Show quoted text -
Date: Mon, 5 Jan 2009 08:43:13 -0800 (PST)
Message-ID: <bc442b77-616c-47cc-8c81-cca07e2ec8ee_at_o4g2000pra.googlegroups.com>
On Jan 5, 10:26 am, wallyr..._at_gmail.com wrote:
> 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- Hide quoted text -
>
> - Show quoted text -
As I thought.
Thank you for the update.
David Fitzjarrell Received on Mon Jan 05 2009 - 10:43:13 CST