Re: backup/restore of a table with multiple xmltype columns failing
From: bdbafh <bdbafh_at_gmail.com>
Date: Tue, 6 Jan 2009 11:57:00 -0800 (PST)
Message-ID: <cfba2742-2866-4cd4-8ce7-4eabc110f6d9_at_r10g2000prf.googlegroups.com>
On Jan 6, 10:41 am, wallyr..._at_gmail.com wrote:
> On Jan 6, 10:28 am, bdbafh <bdb..._at_gmail.com> 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.
>
> > did you use exp or expdp to prepare the dump file?
>
> > -bdbafh
>
> we used expdp as noted in the orginal post
Date: Tue, 6 Jan 2009 11:57:00 -0800 (PST)
Message-ID: <cfba2742-2866-4cd4-8ce7-4eabc110f6d9_at_r10g2000prf.googlegroups.com>
On Jan 6, 10:41 am, wallyr..._at_gmail.com wrote:
> On Jan 6, 10:28 am, bdbafh <bdb..._at_gmail.com> 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.
>
> > did you use exp or expdp to prepare the dump file?
>
> > -bdbafh
>
> we used expdp as noted in the orginal post
Right. Sorry about that.
Please refer in Metalink to
Doc ID: 443373.1
Ora-39139: Data Pump Does Not Support Xmlschema Objects
I've observed that error in expdp on MS Win32 with 10g R2 with the 10.2.0.4 patchset in place.
hth.
-bdbafh Received on Tue Jan 06 2009 - 13:57:00 CST