Problem To Migrate Table With Table Type P From DB/AS400 With OMWB
Last updated on JANUARY 19, 2017
Applies to:Oracle Migration Workbench - Version 10.2.0.4 and later
Information in this document applies to any platform.
You want to migrate a DB2 database from an AS400 server with Oracle Migration Workbench and you cannot migrate all your tables.
If you use strsql on the AS400 server to check your tables:
Select * from systables
You can see the tables with the attribute TABLE_TYPE = 'T' are migrated perfectly but the tables with the attribute TABLE_TYPE = 'P' are not 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