Export table with XMLType column

[Cube874]

I have a table that has a column that is an XMLType. I need to export the data as a DML but when I try to export using "SQL Inserts" or "PL/SQL Developer" type exports, I get an error: "Table

contains one or more XMLType columns. Cannot export in SQL format."

I tried usingt the Oracle export, but there is no "exp*.exe" executable in my Oracle BIN directory (C:\oracle\product\10.2.0\client_1\BIN\).

I need to get this data into some kind of DML file so I can send the updates to the rest of the team. How can I do this?

(We're running Version 7.1.5.1398; unlikely to upgrade to the next version until this project is finished - unless it's absolutely necessary)

 

[Marco Kalter]

This is not possible. The XML text can become too large for a SQL file with insert statements.

If the XML contents are all smaller than 4000 bytes, then you could create a custom script to generate the insert statements. The standard export tool will not help though.

 

[Cube874]

The XML contents are significantly larger than 4000 bytes. I am storing XSL files for transformation. I need to be able to create DDL and DML scripts that will recreate the application. Any other tips?

 

[Marco Kalter]

My suggestion would be to install Oracle's standard exp and imp utilities.