Object type

Feature

Supported

Table

Standard relational tables

YES

Partitioned (range, hash and composite) Tables (Available in Oracle 8.0.x onwards)

YES

Partitioned (list) Tables (Available in Oracle 9.x onwards)

NO

Object tables (Available in Oracle 8.0.x onwards)

NO

Index-organized tables (Available in Oracle 8.0.x onwards)

YES

Temporary tables (Available in Oracle 8.0.x onwards)

YES

External tables (Available in Oracle 9.x onwards)

NO

XMLType Table

NO

Physical Attributes (PCT_FREE, PCT_USED, INI_TRANS, MAX_TRANS)

YES

Storage Attributes (INITIAL_EXTENT, NEXT_EXTENT, MIN_ EXTENT, MAX_ EXTENT, PCT_INCREASE, FREELISTS, FRELIST_GROUPS, BUFFER_POOL)

YES

Table Properties (LOGGING, COMPRESSION, CACHE, DEGREE, MONITORING)

YES

Default for not null column (to be done)

YES

IOT

YES

Cluster table

YES

Table/Column comments

YES

Storage Partitions

YES

Storage Sub-partitions

YES

Lob Storage

YES

Index Properties (LOGGING, COMPRESSION, DEGREE)

YES

Index Storage Partitions

YES

Index Storage Sub-partitions

YES

Index

Standard

YES

Unique

YES

Bitmap

YES

Bitmap Join Index (Available in Oracle 9.x onwards)

NO

Cluster

YES

Descending (Available in Oracle 8.1.x onwards)

YES

Reverse key (Available in Oracle 8.0.x onwards)

NO

Partitioned (Available in Oracle 8.0.x onwards)

YES

LOB

YES

Global (Available in Oracle 8.0.x onwards)

YES

Local (Available in Oracle 8.0.x onwards)

YES

Non-prefixed (Available in Oracle 8.0.x onwards)

NO

Pre-fixed (Available in Oracle 8.0.x onwards)

NO

Function-based (Available in Oracle 8.1.x onwards)

YES

Constraints

Primary keys

YES

Unique keys

YES

Check

YES

Foreign keys

YES

External FKs, views FKs (Available in Oracle 9.x onwards)

NO

Materialized view

Index-Organized Materialized Views (Available in Oracle 9.x onwards)

YES

Indexes on Materialized Views (Available in Oracle 9.x onwards)

YES

Partitioned

YES

LOB

YES

XML, nested table, varray type columns (Available in Oracle 9.x onwards)

NO

Materialized view log 

YES

Snapshots (Oracle 7.3.4 upto Oracle 8.0.x Only)

Simple and complex

YES

Registered

YES

Read-only and updateable

YES

Complete, ROWID and primary key fast refreshes

YES

Snapshot logs (Oracle 7.3.4 upto Oracle 8.0.x only)

General

YES

Record with Object ID or Sequence (Available in Oracle 9.x onwards)

NO

Job  

YES

Trigger

Standard

YES

Instead-of (Available in Oracle 8.0.x onwards)

YES

Database-event (Available in Oracle 8.0.x onwards)

NO

Nested-table view triggers (Available in Oracle 8.1.x onwards)

NO

View

Standard views

YES

Inline views

YES

Object views (Available in Oracle 8.0.x onwards)

NO

Join views (including updateable) (Available in Oracle 8.0.x onwards)

NO

Check option on views (Available in Oracle 8.0.x onwards)

NO

Read only option on views (Available in Oracle 8.0.x onwards)

NO

Polymorphic Views (Available in Oracle 9.x onwards)

NO

Views Hierarchies (Available in Oracle 9.x onwards)

NO

Views with Constraints (Available in Oracle 9.x onwards)

NO

Synonyms

Synonyms using DB Links

YES

Cluster 

TABLESPACE

YES

INDEX

YES

SINGLE TABLE

YES

ROWDEPENDENCIES

YES

SIZE

YES

CACHE

YES

HASH

YES

HASH EXPRESSION

YES

HASHKEYS

YES

Physical Attributes

YES

Storage Attributes

YES

Package 

Header

YES

Body

YES

Invokers Right (Available in Oracle 8.0.x onwards)

YES

Procedure

Java/C Methods Calls (Available in Oracle 8.0.x onwards)

NO

Invokers Right (Available in Oracle 8.0.x onwards)

YES

Function

Java/C Methods Calls (Available in Oracle 8.0.x onwards)

NO

Invokers Right (Available in Oracle 8.0.x onwards)

YES

Sequence       

INCREMENT

YES

START

YES

MAXVALUE

YES

MINVALUE

YES

CYCLE

YES

CACHE

YES

ORDER

YES

DB link

SHARED

YES

CONNECT

YES

IDENTIFIED BY

NO

CURRENT_USER

YES

USING

YES

Datatype

Feature

Supported

Built-in Datatypes

String Datatypes

Character

YES

CHAR

YES

NCHAR (Available in Oracle 8.0.x onwards)

YES

VARCHAR2

YES

LONG

YES

CLOB (Available in Oracle 8.0.x onwards)

YES

NCLOB (Available in Oracle 8.0.x onwards)

YES

Numeric Datatypes

Number

YES

Date types

DATE

YES

TIMESTAMP (Available in Oracle 9.x onwards)

YES

TIMESTAMP WITH TIME ZONE (Available in Oracle 9.x onwards)

YES

TIMESTAMP WITH LOCAL TIME ZONE (Available in Oracle 9.x onwards)

YES

INTERVAL YEAR TO MONTH (Available in Oracle 9.x onwards)

YES

INTERVAL DAY TO SECOND (Available in Oracle 9.x onwards)

YES

Binary data types

RAW

YES

LONG RAW

YES

BLOB

YES

BFILE (Available in Oracle 8.0.x onwards)

YES

IDs

(not relevant)

ROWID

YES

UROWID (Available in Oracle 8.0.x onwards)

YES

ANSI  DB2, SQL/DS datatypes

(not relevant)

User defined data types (Available in Oracle 8.0.x onwards)

Collection Types

NO

Object Types

NO

Oracle Supplied types

NO

"Any" Types (Available in Oracle 9.x onwards)

NO

XML Types (Available in Oracle 9.x onwards)

NO

Spatial Types

NO

Media Types (Available in Oracle 8.1.x onwards)

NO

Context Text Types

NO

TNS_ADMIN variable is not supported.

CR#0198569

Arguments in Scheduled_program are not supported.

CR#0205841

Jobs are displayed as different even when connecting to the source and target as the same user.

CR#0193943

Storage Attribute in Compare Option is not applied for Tables and Indexes in compare panels when set to "Ignored in comparison and do not ignore in scripting".

CR#0209506

Materialized view Prebuild tables are displayed as different in the result pane, if there is a difference in the Prebuilt table storages.

CR#0209375

No supported objects and properties

• Overflow clause and its storage are not supported in Index organised tables

• In IOT Materialized Views, overflow clause is supported only with 'including column clause' option, but without 'storage attributes'.

• In IOT Tables, overflow clause is not supported. "Including column name" and "Overflow storage" are not displayed in the create/synch scripts of IOT tables.

• On sync, Oracle may add 'DISABLE STORAGE IN ROW' for the particular column. As a result, all column data will get stored in the associated LOB storage.

• The Nested tables and Table types are not supported and the script generated may be incorrect

• Objects containing the FORCE VIEW option are not supported (the script is  generated incorrectly and no sync message is generated).

• Such Materialized Views Refresh Cycles as start and next are omitted in scripts for auto refresh Materialized Views .

• In Materialized Views, Organization Heap and External are not supported.

• For Oracle 8i - Partitioned and sub-partitioned tables does not synchronize (no sync alert is given)

• For Oracle 9i -  

• For Hash partitioned tables: The system generated partition names are not displayed. If there is no partition name for the partition, the script may fail.

• For sub-partitions: The system generated sub-partition names are not displayed. If there is no sub-partition name for the sub-partition, the script may fail.

CR#0203296

Script generation

Sometimes the sync script for Bitmap join Indexes fail to synchronize.

CR#0203590

If a unique constraint has a unique index, the sync scripts from source to target and from target to source are generated incorrectly.

CR#1977410