SECUREFILE keyword missing for BINARY XML
Paul Dziemiela <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <93E6FC4F2C85054AA824949283899D2EB191AAD830@HW3SP-EXCHQ1.induscorp.com> |
Using Toad 11.0.0.116 CREATE TABLE foo ( trans_id VARCHAR2(2000 BYTE), trans_user VARCHAR2(2000 BYTE), trans_xml SYS.XMLTYPE, trans_sdo MDSYS.SDO_GEOMETRY ) XMLTYPE trans_xml STORE AS SECUREFILE BINARY XML VARRAY trans_sdo.SDO_ELEM_INFO STORE AS SECUREFILE LOB ( ENABLE STORAGE IN ROW ) VARRAY trans_sdo.SDO_ORDINATES STORE AS SECUREFILE LOB ( ENABLE STORAGE IN ROW ); The TOAD script playback misses the SECUREFILE keyword on the BINARY XML but it shows things fine on the VARRAY LOBs. Note that I cannot actually view BINARY XML in a TOAD query grid without the application crashing (client 11.2.0.1 UTF8 instance). Cheers, Paul