Export user with xml data in table

Toad for Oracle & DevOps Toolkit
1

Hi,

I have executed a user and included all tables etc. I have some tables fail to export because of xml data in the table. How do I overcome this? I have version 12.7 installed

Thanks.

Steve Williams

2

I have executed a user

That's a little harsh, don't you think? What did he do?

Just kidding.

You need to query the XML data as a CLOB using GetClobVal() and then it should work fine. For example:

SELECT
t.column1, t.column2,
t.XMLTYPE_COLUMN.GetClobVal() as XMLTYPE_COLUMN
FROM my_table t;

An alias is required for GetClobVal to work.

3

This is the export message for the table:

EXP-00107: Feature (BINARY XML) of column XMLSTREAM in table SAUTO_17_1.IX_SPC_PLANOGRAM is not supported. The table will not be exported.

Does your solution still apply? Can a configuration setting in the export wizard handle this?

Thanks.

4

Oh, that kind of export. I thought you meant “export table data”.

Hm, no, I don’t think so…but give datapump a try. I wouldn’t be surprised if it works in datapump.

5

I logged in as the user/schema, ran the export dump wizard, that worked without complaining. Thanks for the suggestion