Oracle® Features Supported by TOYS

Oracle is a registered trademark of Oracle Corporation.

The table below lists those Oracle features that TOYS currently supports.

The Ver column indicates the version of the Oracle server when the feature was first supported by Oracle. Features available prior Oracle 7 are simply shown as "7".

The following four columns indicate whether the feature is supported in the following functional areas of TOYS:

The following symbols have been used to indicate the level of support for each feature:

		Feature is not supported.
		Feature is only partially supported.
		Feature is fully supported [exceptions as noted].
	-	Feature is not applicable to schema synchronization.

To determine features supported by earlier versions of TOYS, see TOYS Release History for a summary of the changes made in each release.

Tables

Oracle Feature Ver M C D S Notes Relational Tables 7 Relation tables containing object type columns are only partially handled in the synchronization. Object Tables 8 Object tables are only partially supported. XMLTYPE Tables 9 Tables of XMLTYPE are fully supported except for synchronization. Heap Tables 7   Hash Clustered Tables 7   Sorted Hash Clustered Tables 10   Index Tables 8   Temporary Tables 8i   External Tables 9   Partitioned Tables 8 Support for table and index partitioning is expected to be released by:- DDL: end of August 2010, Comparisons: end of Oct 2010, Synchronization: end of 2010.

Views

Oracle Feature Ver M C D S Notes Relational Views 7   Object Views 8i   Check Option 8   Read Only Option 8

Constraints (relational tables)

Oracle Feature Ver M C D S Notes Not Null Constraints 7   Check Constraints 7   Primary Keys 7   Unique Keys 7   Foreign Keys 7 Constraints are not currently supported for object tables.

View Constraints

Oracle Feature Ver M C D S Notes Primary Keys 8i   Foreign Keys 8i

Stored Procedures

Oracle Feature Ver M C D S Notes Procedures 8   Functions 8

Stored Packages

Oracle Feature Ver M C D S Notes Package Declarations 8   Package Specifications 8

Indexes

Oracle Feature Ver M C D S Notes B+Tree Indexes 7   Cluster Indexes 7   Bitmap Indexes 7   Bitmap Join Indexes 9   Function-based Indexes 8i   Domain Indexes 8i   LOB Indexes 8   IOT Top Indexes 8i   IOT Nested Indexes 8i   Secondary Indexes 8i

Indexes Features

Oracle Feature Ver M C D S Notes Descending Column Indexes 8i   Reversed Key Indexes 8   Compressed Key Indexes 8   Index Partitioning 8i See notes for table partitioning.

Materialized Views

Oracle Feature Ver M C D S Notes Materialized views 7 Partially supported for comparisons. Partially supported for DDL generation. Not supported for synchronization. Full support for Materialized Views is not expected anytime soon. Materialized view logs 7   Refresh Groups 8

Character Datatypes

Oracle Feature Ver M C D S Notes CHAR 7   NCHAR 8   VARCHAR2 7   NVARCHAR2 8   LONG 7   CLOB 8   NCLOB 8

Numeric Datatypes

Oracle Feature Ver M C D S Notes NUMBER 7   FLOAT 7   INTEGER 7   BINARY FLOAT 10   BINARY DOUBLE 10

Date-Time Datatypes

Oracle Feature Ver M C D S Notes DATE 7   TIMESTAMP 9   TIMESTAMP (TZ) 9   TIMESTAMP (local TZ) 9   INTERVAL (year-month) 9   INTERVAL (day-time) 9

Binary Datatypes

Oracle Feature Ver M C D S Notes RAW 7   LONG RAW 7   BLOB 8   BFILE 8

Misc Datatypes

Oracle Feature Ver M C D S Notes ANSI, DB2 Datatypes 7 Oracle treats ANSI and DB2 data types as synonyms for its own data types and thus no special handling is required by TOYS. ROWID 7   UROWID 8   MLSLABEL 7 Label data types require Secure Oracle.

Object Data Types

Oracle Feature Ver M C D S Notes User Defined Types 8 Fully supported for DDL generation. Supported for comparison and synchronization with restrictions. In essence, UDTs owned by schemas that are not included in the snapshot are not compared and thus an altered UDT in a non core schema will not currently be reflected in the dependent UDT or table. This needs work! Additionally, preservation of row data in tables containing UDTs is not currently supported for synchronization. Collection Types 8

Oracle Specific Data Types

Oracle Feature Ver M C D S Notes ANYTYPE 9   XMLTYPE 9 There are limitations in the synchronization of tables containing columns of XMLTYPE. Spatial Types 8   Media Types 8i   Context Text Types 8

Triggers

Oracle Feature Ver M C D S Notes Tables Triggers 7   Views Triggers 8   Schema Triggers 8   Database Triggers 8 Although TOYS will synchronize database triggers this is not applicable to schema synchronization. Nested-table View Triggers 8i

Table Clusters

Oracle Feature Ver M C D S Notes Index Clusters 7   Hash Clusters 7   Single Table Hash Clusters 8

Database Links

Oracle Feature Ver M C D S Notes Public Database Links 7 - Public links are not applicable for synchronization. Private Database Links 7

Synonyms

Oracle Feature Ver M C D S Notes Public Synonyms 7   Private Synonyms 7

Extensible Indexes

Oracle Feature Ver M C D S Notes Index Types 8i   Operators 8i

Java support

Oracle Feature Ver M C D S Notes Java Classes 8   Java Source 8

Privileges

Oracle Feature Ver M C D S Notes Granting of System Privileges 7 TOYS does not currently capture or compare system privileges granted to roles or schemas. Granting of Roles 7 TOYS does not currently capture or compare the roles granted to other roles or schemas. Granting of Object Privileges 7 Granting of object privileges (including column level privileges) is supported for capture, DDL generation, comparisons and synchronization. The WITH GRANT OPTION is supported, however, the WITH HIERARCHY OPTION is not supported as it is not applicable.

User Management

Oracle Feature Ver M C D S Notes User Definitions 7 TOYS does not currently capture user definitions (e.g. PASSWORD, DEFAULT TABLESPACE, tablespace quotas, etc.). Object grants to users are captured, compared and synchronized. Profiles 7   Role Definitions 7 TOYS does not currently capture definitions of roles. Object grants to roles are captured, compared and synchronized.

Misc Schema Types

Oracle Feature Ver M C D S Notes Libraries 8 The definitions of libraries are captured, compared and synchronized but the actual libraries are not. Sequences 7   Jobs 7

Non-Schema Types

Oracle Feature Ver M C D S Notes Dimensions 8i   Directories 8   Outlines 8i   Histograms 7   Sum Deltas 8i   Row level dependency tracking 9 This feature is supported at the table definition level. Resource Costs 8   Rulesets 8i   Tablespace Definitions 7 - - - - Tablespace names of object segments are captured, compared and included in generated DDL. The actual definition of the tablespaces is considered outside the scope of schema synchronization. Audit options 8 - - - - Considered outside the scope of schema synchronization. Fine grained access control 9