backup/restore of a table with multiple xmltype columns failing

From: <wallyraju_at_gmail.com>
Date: Mon, 5 Jan 2009 06:57:50 -0800 (PST)
Message-ID: <3587a5f9-4ccc-4308-b97a-5c57cd2604fd_at_y1g2000pra.googlegroups.com>

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. Received on Mon Jan 05 2009 - 08:57:50 CST