Re: backup/restore of a table with multiple xmltype columns failing
From: bdbafh <bdbafh_at_gmail.com>
Date: Tue, 6 Jan 2009 07:28:58 -0800 (PST)
Message-ID: <1b215cf1-9363-4c07-8b64-0da4f804a724_at_e25g2000vbe.googlegroups.com>
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.
Date: Tue, 6 Jan 2009 07:28:58 -0800 (PST)
Message-ID: <1b215cf1-9363-4c07-8b64-0da4f804a724_at_e25g2000vbe.googlegroups.com>
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 Received on Tue Jan 06 2009 - 09:28:58 CST