cancel
Showing results for 
Search instead for 
Did you mean: 

Can partitioned tables be migrated from Oracle to Postgres ?

Question

 Can partitioned tables be migrated from Oracle to Postgres ?

Answer

 Migration Toolkit migrates object definitions (DDL), table data, or both. 

The following link contains a platform-specific list of the types of database objects that Migration Toolkit can migrate:

https://www.enterprisedb.com/docs/en/50.0/migrate/EDB_Postgres_Migration_Guide.1.07.html#

Version history
Revision #:
1 of 1
Last update:
‎06-12-2017 05:56 PM
Updated by:
 
Labels (3)
Contributors
Comments
jsoler

Last version of MTK has some problems with partitioned tables

Errors: 
Creating Table: "EXTRACT_CERT" 
2018-11-02 13:25:05 MTK-15013: Error Creating Table "EXTRACT_CERT" 
java.lang.NullPointerException 
2018-11-02 13:25:05 Stack Trace: 
com.edb.MTKException: MTK-15013: Error Creating Table "EXTRACT_CERT" 
at com.edb.MigrationToolkit.copyTables(MigrationToolkit.java:4515) 
at com.edb.MigrationToolkit.copyTables(MigrationToolkit.java:4432) 
at com.edb.MigrationToolkit.importSchema(MigrationToolkit.java:4120) 
at com.edb.MigrationToolkit.main(MigrationToolkit.java:2015) 
Caused by: java.lang.NullPointerException 
at com.edb.common.MTKTransformDDL.getOraPartitionTableDDL(MTKTransformDDL.java:328) 
at com.edb.dbhandler.redwood.PGTransformDDL.getCreateScript(PGTransformDDL.java:94) 
at com.edb.MigrationToolkit.copyTables(MigrationToolkit.java:4495)