I am using Oracle 12c to test migration from Oracle to PostgreSQL. I am using windows OS. I have copied ojdbc7.jar file under lib folder of "EnterpriseDB-MigrationToolkit"
I am getting following error:
E:\sandeep\postgres\EnterpriseDB-MigrationToolkit>runMTK.bat -verbose on -source dbtype "oracle" @//localhost:1521/pdbsales.igatecorp.com Source database connectivity info... conn =jdbc:oracle:thin:@//localhost:1521/pdbsales.igatecorp.com user =scott_name password=****** Target database connectivity info... conn =jdbc:postgresql://localhost:5432/postgres user =postgres password=****** Connecting with source Oracle database server... Error: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
Hi Sandeep,
As from the error log it seems that you haven't added oracle-jdbc driver to the classpath. You can do so by running command something like -- export CLASSPATH= "$CLASSPATH:path/to/jar/file"
Hope this helps.
One or more schema objects could not be imported during the migration process. P lease review the migration output for more details.
Migration logs have been saved to C:\Users\gondhasa.IGATECORP\.enterprisedb\migr ation-toolkit\logs
