What's New › Support for Oracle 11g

Support for Oracle 11g

CA ERwin Data Modeler now supports creating models for Oracle 11g databases. The new properties such as virtual on column and invisible index are supported. Full support for partitions on table, materialized view, and materialized view log is included.

The following objects are supported:

• Cluster
• Database
• Database Link
• Directory
• Disk Group
• Index
• Library
• Package
• Partition
  • List
  • Range
  • Hash
  • System Partition
  • Reference Partition
  • Interval Partition
  • Composite (Range–Range)
  • Composite (Range–List)
  • Composite (Range–Hash)
  • Composite (List–Range)
  • Composite (List–Hash)
  • Composite (List–List)
  • Composite (Interval–List)
  • Composite (Interval–Range)
  • Composite (Interval–List)
  • Composite (Hash-Range)
  • Composite (Hash-List)
  • Composite (Hash-Hash)
• Rollback Segments
• Sequences
• Synonyms
• Tables
• Tablespaces

Note: The following properties are not supported for the partitioning feature:

• Table compression (only the COMPRESSION and NOCOMPRESSION parameters are supported)
• VARRAY parameters
• STORAGE parameters such as, ENCRYPT, FLASH_CACHE, OPTIMAL, and maxsize_clause
• LOB SECUREFILE and BASICFILE
• New COMPRESS setting with hash_partitions_by_quantity clause
• SEGMENT CREATION IMMEDIATE/DEFERRED
• Deduplication

More information:

Define Oracle Table Column Properties