The EDB Postgres Migration Portal Repair handler manages the incompatibilities between Oracle and EDB Postgres. In case, of errors you can check the error details in the Assessment output, and based on the error type, you can take one of the following options:
Apply the fix and run the assessment.
Refer to the Knowledge Base table to resolve the error. (link)
Refer to the online documentation to resolve the error. (link)
In case you do not find a solution in the Knowledge Base and the online documentation, you can post your query on the PostgresRocks.com forum, and the EDB team member will respond with a possible solution.
In the following example, a table with a column named PARTITION is used to remove the incompatibility between Oracle and EDB Postgres. However, EDB Postgres does not support PARTITION.
To remove the incompatibilities complete the following steps:
1. Create a project in EDB Postgres Migration Portal and load the extracted script from Oracle.
2. Run the assessment. In case, the assessment fails, check the error details.
3. EDB Postgres does support table column named PARTITION. You must enclose PARTITION in double quotes and click ASSESS. Following image displays a successful transformation.