This discussion is archived
0 Replies Latest reply: Apr 26, 2012 10:24 AM by cjohnson RSS

Schema name in generated DDL is not Database Schema Name property value

cjohnson Newbie
Currently Being Moderated
The Database Schema Name property value is not used for the schema name in generated Oracle DDL. The schema name in generated Oracle DDL is derived from the EntityContainer name in the SSDL. If the Namespace is set to "MyNamespace", and the EntityContainer in the SSDL and the corresponding StorageEntityContainer in the MSL are set to "MySchema", then the generated DDL will use "MySchema" as the schema name, as desired. However, the Database Generation Wizard changes the EntityContainer and StorageEntityContainer names to "MyNamespaceStoreContainer". So after each Oracle DDL generation, you must either change EntityContainer and StorageEntityContainer, or change the schema name in the generated Oracle DDL, back to "MySchema". Thus, there are two bugs in the Oracle DDL generation. First, the DDL should use the schema name specified by the Database Schema Name property. Second, the Database Generation Wizard should not reset the EntityContainer and StorageEntityContainer names to their default values if those values have been changed.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points