During Migrating From DB2 To Oracle with SQLDeveloper, Desc Index at DB2 Becomes Asc at Oracle
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.
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.
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