Re: backup/restore of a table with multiple xmltype columns failing

From: <wallyraju_at_gmail.com>
Date: Tue, 6 Jan 2009 07:41:46 -0800 (PST)
Message-ID: <234c8db9-b850-4d41-92be-878e1af68007_at_w1g2000prm.googlegroups.com>

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 Received on Tue Jan 06 2009 - 09:41:46 CST