Source database | Target databases |
---|---|
DB2® Version 9.5 for Linux, UNIX, and Windows |
|
DB2 Version 9.7 for Linux, UNIX, and Windows |
|
DB2 Version 9 for z/OS |
|
Oracle Database 10g |
|
Oracle Database 11g |
|
CREATE <UNIQUE> INDEX index_name ON table_name (column_name ASC|DESC);
Additionally, synonyms for nicknames are supported for copying from a DB2 for Linux, UNIX, and Windows source to an Oracle target. In DB2, synonyms are also referred to as aliases.
You can copy synonyms without the objects that they refer to. However, if an object whose synonym you copy does not exist in the target database, the server throws an error that indicates the missing object.
All sequence parameters except CACHE are supported for copying.