During Migrating From DB2 To Oracle with SQLDeveloper, Desc Index at DB2 Becomes Asc at Oracle

(Doc ID 2419314.1)

Last updated on JULY 16, 2018

Applies to:

Oracle SQL Developer - Version 17.3.1 and later
Information in this document applies to any platform.

Symptoms

You are using Oracle SQL Developer Migration Workbench to migrate DB2 to Oracle.
DB2 database has:


CREATE INDEX <schema name>.<index name> ON <schema name>.<table name>
("<columns name>" DESC)

However, the INDEX created by specifying DESC option in DB2 becomes ASC in Oracle database when migrated.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms