Oracle SQL Developer Data Modeler 2.0 (2.0.0.584)

Patch 1 - Bugs Fixed

December 2009

This list is not all-inclusive. Since July 2009, the SQL Developer Data Modeler team have closed many bugs. Many of these are picked up as the developers are working with the product and range from trivial to more complex issues. This list is a selection of higher priority bugs, customer bugs in Metalink and a selection of those reported by the community on the forum.


  • General
    • 8771482: Data type of FK column/attribute doesn't follow the changes in PK column/attribute
    • 8358081: Encode/decode of special xml characters during save/open operation
    • 8814953: Naming standards/design rules-table abbreviation shows warning when included in name template
    • 8570013: Data modeler hangs on “open” and “save as” operations
    • 8991484: Same shortcut key for save physical model and RDBMS site admin
  • DDL
    • 8525591: Name containing space is put into DDL without surrounding double quotes (SQL Server)
    • 8716575: Data type varchar(30) is generated as "varchar" for SQL Server
    • 9024826: Compare DDL preview unload script: error if column name is 'scale'/contains #
    • 9027435: Compare DDL preview unload script: error if data value longer than 255 chars
    • 9063564: Advanced DDL - stop exec. after backup, actually stops after table is dropped
    • 8932795: Oracle 10g: Admin and public options missing in the DDL generated for role
    • 8636012: DDL generated for external table created by import-data dictionary is incorrect
    • 8898373: SQL Server 2005 DDL generation options window - none of the objects are listed
    • 9109967: Invalid DDL generated for a lob storage associated with a hash partition
    • 9109095: Primary key error ora-02260 on applying DDL generated for a materialized view
    • 9036713: DDL generation - indexes are created without user/schema in their name
    • 9118133: Invalid DDL generated for external table's CLOB columns
  • Diagram and UI
    • 8672244: Column groups cannot be deleted in table dialog
    • 8233339: Foreign key/relationship presentation is deleted from subview/display when saving and then reopening diagram
    • 8965555: Attribute doesn't keep its position if added using ctrl/add or shift/add
    • 8972128: Table dialog - wrong check for mandatory foreign key - recognize it as optional
    • 9104083: Table dialog - inconsistent behavior for FK columns added to primary key
    • 8641604: Column properties editor displays old value for data type
    • 7535389: Align left align top shot key doesn't work, problems with edit menu
    • 8726023: Number added in column name after using copy
    • 8967989: Generate in DDL not stored when creating a foreign key
    • 8975979: SQL Server 2005: change user name field to be editable
    • 8941812: Type administration "save" button disabled
    • 7655644: FK attributes to be seen at relationship level (dialog)
    • 8726999: Create and edit of spatial indexes doesn't work
  • Domains
    • 8910688: Domains are not imported from non versioned designer repository
  • Engineering between logical and relational models
    • 8904081: Newly generated FKs not shown in subviews of relational model after engineering from logical model
    • 8947522: The name of column/attribute constraint is not included in forward and reverse engineering and merge
    • 9108587: Engineer to logical model -- relationships are not shown in subviews
    • 8612504: Order of attributes is in sync only on first engineering to relational model
    • 8631015: Synchronizing relational to logical model changes the sub type name in logical model
  • Importing and Exporting
    • 8323363: Granted roles are not imported during import from db dictionary
    • 8255621: Xmltype storage settings are not generated in DDL (CLOB or object relational)
    • 8786717: Cannot import from Teradata using JDBC import
    • 8580616: Imported structured/collection types have wrong names after compare/merge
    • 8722596: Wrong column is taken in comp./merge even if there is a column with the same name
    • 8967562: DDL preview/generation failed when there is "$" character in view name
    • 9031197: Import from ERwin 4.x -design cannot be open properly after save, messages in log
    • 8794686: JDBC import -cannot import FK based on two and more columns
    • 8799308: Table comments are not imported when import from Oracle dictionary
    • 8586880: Generate DDL for create cluster is created with column of unknown data type
    • 8639759: Import script with DDL to create role removes system privilege of existing role
    • 8941508: Compare/alter statements: All foreign key are recreated when one foreign key is deleted
    • 8632257: Save password unchecked, still saves the password.
    • 8631000: Import SQL Developer database connections dialog displays,xml files twice
    • 9001800: Compare mapping doesn't appear in import from database and DDL, options
    • 9011419: SQL Server 2005-import of user defined data type integer is changed to unknown
    • 9118001: Invalid 'using CLOB phrase generated in external table access parameters
    • 9133705: Import from DDL file may not work if it includes literals containing quotes
    • 8976028: Import/DDL generation of cluster with interval and timestamp columns
    • 8342636: Optional import of domains from designer repository
    • 8989254: Import from Oracle 10g - list partitioning is imported as range partitioning
  • Reporting Repository
    • 916607: Export to reporting schema exports empty PDF for diagrams
  • Models: Logical
    • 9124456: Can't reorder attributes when created initially
  • Models: Relational
    • 8947317: Column groups are not copied in copy/paste of table - columns are removed
    • 8574041: Different table level constraints will use same name after apply naming rules
    • 8692532: Max name length for FK and index revert to 18 when model properties are edited
    • 8566505: Naming standard:"_1" is added for system generated object name
    • 8562370: Naming standard:template {column} not replaced by column name
    • 8353805: DDL generation incorrect for grant privileges on user
    • 8574505: Copied FK name show in the diagram is not consistent with actual FK name
  • Models: Physical
    • 9079797: RDBMS site path ids are not unique; not possible to open physical models created
    • 8623189: Export DDL for cluster
    • 8635181: Export DDL for synonym: imported synonym takes null as dblink
    • 8623118: Export DDL for context: context name is not included in the DDL
    • 8635104: Export DDL for snapshots: no DDL generated for imported materialized view
    • 8586546: Cluster size suffixed by k or m cannot be generated into Oracle 9i database
    • 8893194: Export DDL for cluster: column size not exported
    • 8623693: Create sequence: cache should have a default value
    • 9091064: Cannot set lob column in lob item properties for a hash subpartition
    • 9118922: BLOB, CLOB missing from data types allowed in external table column props dialog
    • 8722310: Save does not save physical model changes
    • 8904160: Default user doesn't remain after reopening physical model for Oracle
  • Models - Multidimensional
    • 9037702: Cannot create more than two hierarchies in a dimension
    • 8786767: Label (name) of role-playing dimension is not shown on dimensional diagram
  • Models - Process
    • 8727463: Transformation tasks are not included in "save as" operation
  • Data Types
    • 9010530: Distinct type: can't input size for varchar when creating