Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Oracle DDL files use outdated syntax

Description

The syntax used in the auto-generated DDL files for oracle use old syntax that is less than optimal on Oracle 10g et seq. In particular, "timestamp" datatype should be used instead of "date", and "varchar2(255 char)" should be used instead of "varchar2(255)".

Environment

None

Test Plan

None

Attachments

1

Activity

Show:

Jim Eng January 4, 2011 at 9:10 AM

That files includes two extra columns and an extra index: EVAL_EVALUATION.LOCAL_SELECTOR, EVAL_EMAIL_TEMPLATE.EID and eval_emailtemplate_eid. Those will be covered under separate tickets.

Jim Eng January 4, 2011 at 9:04 AM

Attaching copy of DDL script for Oracle 10g.

Won't Fix

Details

Assignee

Reporter

Components

Affects versions

Priority

Created January 4, 2011 at 8:43 AM
Updated March 23, 2012 at 8:19 AM
Resolved March 23, 2012 at 7:41 AM