The Exported DDL show the DDL if for Oracle 8.1.6 ------------------------------------------------- Key: TEIIDDES-3109 URL: https://issues.jboss.org/browse/TEIIDDES-3109 Project: Teiid Designer Issue Type: Quality Risk Environment: JBDS 10.4 under JDV 6.3 Reporter: Kylin Soong Once export the DDL, the file shows the DDL is for Oracle 8 {code} - Build Script -- RDBMS : Oracle 8.1.6 -- Generated With : -- Generated On : 2017-09-18 10:55:51 -- Generation Options -- Generate Drop Statements : false -- Convert Table Descriptions to COMMENT ON Statements : true -- Convert Column Descriptions to COMMENT ON Statements : true -- -- Uncomment the following line for use of the logging facility (see last line also) --spool .log -- ---------------------------------------------------------------------------------------------------------------- -- Generate From -- Model : /PetroChinaTest/FederatedDataLayer/A1_EPDM_FBL.xmi -- Model Type : Virtual -- Metamodel : relational (http://www.metamatrix.com/metamodels/Relational) -- Model UUID : mmuuid:d614916d-8573-47b1-933f-78d183716404 -- ---------------------------------------------------------------------------------------------------------------- -- (generated from CD_ACTIVITY) CREATE TABLE CD_ACTIVITY ( ACTIVITY_ID VARCHAR2(32) NOT NULL, PARENT_ID VARCHAR2(32), {code} Customer are confused whether this DDL is fine for exec against Oracle 11