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

From: bdbafh <>
Date: Tue, 6 Jan 2009 07:28:58 -0800 (PST)
Message-ID: <>

On Jan 5, 9:57 am, wrote:
> Operating System: Sun Solaris 10
> Database Version: 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 Received on Tue Jan 06 2009 - 09:28:58 CST

Original text of this message