Toad World® Forums

Extract DDL problem


#1

Hi guys,

  1. Create the following table:

CREATE TABLE xml_data
(id NUMBER,
name VARCHAR2(60),
status VARCHAR2(20),
created_date DATE DEFAULT SYSDATE,
content XMLTYPE)
/

  1. Extract DDL for xml_data - Extract is correct
  2. Extract DDL for xml_data again - Extract is irrelevant.

Regards,

Vadim


#2

Hi Vadmin,

Thank you for your feedback. I have managed to reproduce your issue where the table DDL is extracted, along with the DDL for the xmltype type object. We have raised a change request for this issue and will address this behaviour in a future release.

regards,

Bernard