Toad World® Forums

Problem copying rows with XMLTYPE column


#1

Can someone tell me if this is a regression in 10.6 or an intentional change in functionality? Is there a workaround? BTW, this is on Oracle 10.2.0.4.

We are trying to copy data from a table to the same table in a different schema. The last column of the table happens to be datatype SYS.XMLTYPE. In Toad 9.5, we could right click on the table in the schema browser and choose copy data to another schema. In 10.6 this fails with the following error:

10/7/2010 12:24:06 PM: Table ZYX_DETAILS cannot be copied because it contains an XMLTYPE column.
10/7/2010 12:24:06 PM: Copy Table Data3 (Copy Table Data) finished.

The table similar to the following, but with additional VARCHAR2 and NUMBER columns.

CREATE TABLE XYZ_DETAILS
(
ID NUMBER(12) NOT NULL,
CLIENT VARCHAR2(10) NOT NULL,
FILE_TYPE VARCHAR2(10) NOT NULL,
FILE_NAME VARCHAR2(80) NOT NULL,
RETURN_STRING_XML SYS.XMLTYPE
)
XMLTYPE RETURN_STRING_XML STORE AS CLOB (
TABLESPACE USERS
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
LOGGING
INDEX (TABLESPACE USERS))
TABLESPACE USERS
MONITORING;