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