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,
XMLTYPE RETURN_STRING_XML STORE AS CLOB (
ENABLE STORAGE IN ROW
INDEX (TABLESPACE USERS))